ASP.NET MVC custom routing with default route

2017-06-17 18:01 exe.bat imported from Stackoverflow

I have a bit of problem

I have an MVC site that is working just fine.

I wanted to have SEO friendly urls so I created custom routing that looks like this

{section}/{group}/{manufacturer}

since it has the same number of fields as the default route

{controller}/{action}/{id}

i created in loop in RouteConfig.cs that goes to database and loops Sections table and creates custom routes like

FOOD/{group}/{manufacturer}
SPORT/{group}/{manufacturer}
CARS/{group}/{manufacturer}

and point it to the Sections controller.

It works just fine. The problem I have is that now i need to rename FOOD to FRESH-FOOD and i want to keep old links to FOOD working.

What would you recommend ? How can I solve this ?

Is there a better way to do route Section instead of custom routes ?

See also questions close to this topic

Async Request Failed for webdatagrid in asp.net

i am getting one issue when users trying to go to next page in webdatagrid in asp.net. first page of webdatagrid showing fine but when users try to click on next page the error popup. i am not able to reproduce this error. for error please find the screenshot.

 <igWDG:WebDataGrid ID="wdgCourses" DataKeyFields="LearningId" runat="server" AutoGenerateColumns="False"
                                        EnableDataViewState="false" Width="100%" OnInitializeRow="wdgCourses_InitializeRow"
                                        OnDataFiltered="wdgCourses_DataFiltered" OnPageIndexChanged="wdgCourses_PageIndexChanged"
                                        OnColumnSorted="wdgCourses_SortingColumnSorted" AltItemCssClass="wdgrowstyle"
                                        ItemCssClass="wdgrowstyle">
                                        <AjaxIndicator AltText="Loading..." ImageUrl="../Lytebox/images/loading.gif" />
                                        <Columns>
                                            <igWDG:BoundDataField DataFieldName="LearningId" Key="LearningId" Hidden="true">
                                                <Header Text="LearningID" />
                                            </igWDG:BoundDataField>
                                            <igWDG:BoundDataField DataFieldName="Title" Key="Title" Width="30%">
                                                <Header Text="Course Name" Tooltip="Click here to sort this column"/>
                                            </igWDG:BoundDataField>
                                            <igWDG:BoundDataField DataFieldName="Description" Key="Description" Hidden="true">
                                                <Header Text="Description" Tooltip="Click here to sort this column"/>
                                            </igWDG:BoundDataField>
                                            <igWDG:BoundDataField DataFieldName="Category" Key="Category">
                                                <Header Text="Category" Tooltip="Click here to sort this column"/>
                                            </igWDG:BoundDataField>
                                            <igWDG:BoundDataField DataFieldName="CreatedDate" Key="CreatedDate" DataType="System.DateTime" DataFormatString="{0:MM/dd/yyyy}" HtmlEncode= "False">
                                                <Header Text="Created Date" Tooltip="Click here to sort this column"/>
                                            </igWDG:BoundDataField>
                                            <igWDG:BoundDataField DataFieldName="Details" Key="Details" Hidden="true">
                                                <Header Text="Details" Tooltip="Click here to sort this column"/>
                                            </igWDG:BoundDataField>
                                            <igWDG:BoundDataField DataFieldName="IsMgrApproval" Key="IsMgrApproval" Hidden="true">
                                                <Header Text="IsMgrApproval" Tooltip="Click here to sort this column"/>
                                            </igWDG:BoundDataField>
                                            <igWDG:BoundDataField DataFieldName="IsSplApproval" Key="IsSplApproval" Hidden="true">
                                                <Header Text="IsAuthorApproval" Tooltip="Click here to sort this column"/>
                                            </igWDG:BoundDataField>
                                            <igWDG:TemplateDataField Header-Text="Add" Key="Add" CssClass="gridbutton">
                                            </igWDG:TemplateDataField>
                                        </Columns>
                                        <Behaviors>
                                            <igWDG:Paging PagerAppearance="Bottom" PageSize="15" QuickPages="10" Enabled="true" PageLinkCssClass="pointer" />
                                            <igWDG:Sorting SortingMode="Single" Enabled="true">
                                            </igWDG:Sorting>
                                            <igWDG:Filtering CaseSensitive="false" Alignment="Top" Enabled="true" AnimationType="Bounce" EnableInheritance="True" FilterRuleDropDownHoverItemCssClass="gridfilter" FilterRuleDropDownSelectedItemCssClass="gridfilter" FilterRuleDropDownCssClass="gridfilterbg">
                                                <ColumnFilters>
                                                    <igWDG:ColumnFilter ColumnKey="Title">
                                                        <ConditionWrapper>
                                                            <igWDG:RuleTextNode Rule="Contains" />
                                                        </ConditionWrapper>
                                                    </igWDG:ColumnFilter>
                                                    <igWDG:ColumnFilter ColumnKey="Category">
                                                        <ConditionWrapper>
                                                            <igWDG:RuleTextNode Rule="Contains" />
                                                        </ConditionWrapper>
                                                    </igWDG:ColumnFilter>
                                                </ColumnFilters>
                                                <EditModeActions EnableOnActive="True" EnableOnKeyPress="True" MouseClick="Single" />
                                            </igWDG:Filtering>
                                            <igWDG:ColumnResizing Enabled="false">
                                            </igWDG:ColumnResizing>
                                        </Behaviors>
                                        <EmptyRowsTemplate>
                                            <div style="text-align: center;">
                                                <br />
                                                <br />
                                                No Courses available.
                                            </div>
                                        </EmptyRowsTemplate>
                                    </igWDG:WebDataGrid>

this is code for binding. and the error message is.

this is an urgent issue please let me know your ideas.

.net Core or "clean" .Net for greenfield web project?
.net Core or "clean" .Net for greenfield web project?

Having googled quite a bit, but not really found an answer to whether I should go for .Net core or "normal" .net for a greenfield web project? Given (important!) that its a project (HTML UI + mvc + db) thats never gonna run on anything but windows + IIS. Ever. Period.

For classic .net is all the stuff I know (various Nuget Libs) which has a bunch of functionality I need. For .Net core is??? (give that I DONT need any crossplatform stuff in this project. Ever. Period).

What confuses me is (in the context of the project I've sketched)
1. if .Net Core is meant by MS to replace "classic" .Net in the future? Or live side by side?
2. Does core (eventually) contain ALL the stuff in classic + more, or vica versa ?
Some of it is somehow touched in these posts Target .NET4.6 or .NET Core 1 for greenfield development? but thats before the new .Core 2.0 came out, so I revisit the question

:)

Importing Data from excel to database in more time efficient way

I have a excel file with 7-8 columns and 800-1200rows, That needs to be validated and inserted into database and what i have done is load the excel to a OleDB Datareader and read along the rows.The data are checked and validated and are loaded to datatable and then using SqlBulkCopy they are written off to the server.

        string ConnectionStr = string.Empty;

    if (extension.ToUpper() == ".XLS")
    {
        ConnectionStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/Cookies/BatchFile/" + FileName) + ";Extended Properties=Excel 8.0";
    }
    else
    {
        ConnectionStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("~/Cookies/BatchFile/" + FileName) + ";Extended Properties=Excel 12.0";
    }




        DataTable Err = new DataTable();
        dter.Columns.Add("MainCode", typeof(string));
        dter.Columns.Add("Remarks", typeof(string));


        DataTable DtASBAMaster = new DataTable();
        DtASBAMaster.Columns.Add("ASBARef");
        DtASBAMaster.Columns.Add("ClientCode");
        DtASBAMaster.Columns.Add("BranchCode");
        DtASBAMaster.Columns.Add("ShareHolderAc");
        DtASBAMaster.Columns.Add("CyCode");
        DtASBAMaster.Columns.Add("AcType");
        DtASBAMaster.Columns.Add("DMATId");
        DtASBAMaster.Columns.Add("ClientId");
        DtASBAMaster.Columns.Add("BOId");
        DtASBAMaster.Columns.Add("BankCode");
        DtASBAMaster.Columns.Add("OpenDate");
        DtASBAMaster.Columns.Add("EnteredBy");
        DtASBAMaster.Columns.Add("ApprovedBy");
        DtASBAMaster.Columns.Add("Name");
        DtASBAMaster.Columns.Add("ASBAStatus");

        DataTable Dtimport = new DataTable();
        Dtimport.Columns.Add("BatchNo");
        Dtimport.Columns.Add("BranchCode");
        Dtimport.Columns.Add("AcType");
        Dtimport.Columns.Add("CyCode");
        Dtimport.Columns.Add("MainCode");
        Dtimport.Columns.Add("TranDate");
        Dtimport.Columns.Add("NoOfShare");
        Dtimport.Columns.Add("Name");
        Dtimport.Columns.Add("BankCode");
        Dtimport.Columns.Add("ThisBranch");
        Dtimport.Columns.Add("RegNo");
        Dtimport.Columns.Add("DMATId");
        Dtimport.Columns.Add("ClientId");
        Dtimport.Columns.Add("TakeCharge");


        while (odr.Read())
        {


           //Check values against next table to database -->Database trip 1

            SqlDataReader dr = DataAccess.ASBA.DA_Asba.GetMainCodeAsba(Session["ConnSTR"].ToString(), mainCode: MainCode);
            if (dr.Read())
            {

                //Perform Action if value are inseted in next table 

             }
            else
            {
                if (New == "T")
                {
                    //Fetch Details from someother table in database to load in next table
                      //add to datatable DtASBAMaster

                else {

                  //Add to  datatable Err
                    continue;
                }
            }

          //Calculation and stuffs 


            if (!GetBalance(MainCode, TotalAmount.ToString(), IsChargeASBA))
            {
              //Add to  datatable Err
            }

            else
            {
                if (!MainCodeProcessed.Add(MainCode))
                {
                    dter.Rows.Add(MainCode, "Dublicate Maincode in the Batch");
                    continue;
                }

                Dtimport.Rows.Add(BatchNo, BranchCode, AcType, CyCode, MainCode, SimpleHTTPModule.Today.ToString(), NoOfShare, Name, Session["BranchCodeSelected"].ToString(), Session["BranchCodeSelected"].ToString(), RegisterNo, Dmate, Clientid, IsChargeASBA);

            }

        }
        SqlTransaction myTrans = null;
        conn.Open();
        SqlCommand cmd = new SqlCommand();
        myTrans = conn.BeginTransaction();
        cmd.Connection = conn;
        cmd.Transaction = myTrans;
        try {
            successcount = Dtimport.Rows.Count;
            if (successcount > 0)
            {
                string Qrystring = @"INSERT INTO ASBABatApplyTable(BatchNo,BranchCode,BatchDetails,IsPrinted,IsApproved,EnteredBy,CompanyCode,IsuuedDate,NoOfTrans)
                                values(@BatchNo,@BranchCode,@BatchDetails,@IsPrinted,@IsApproved,@EnteredBy,@CompanyCode,@IsuuedDate,@NoOfTrans)";
                ////Qrystring = Qrystring + " VALUES('" + BatchNo + "','" + BatchDetails + "','F','F','" + EnteredBy + "')";

                cmd.CommandText = Qrystring;
                cmd.Parameters.AddWithValue("@BatchNo", BatchNo);
                cmd.Parameters.AddWithValue("@BranchCode", Session["BranchCodeSelected"].ToString());//
                cmd.Parameters.AddWithValue("@BatchDetails", txtBatchDesc.Text);
                cmd.Parameters.AddWithValue("@IsPrinted", "F");
                cmd.Parameters.AddWithValue("@IsApproved", "F");
                cmd.Parameters.AddWithValue("@EnteredBy", EnteredBy);//
                cmd.Parameters.AddWithValue("@CompanyCode", txtCompanyCode.Text);
                cmd.Parameters.AddWithValue("@IsuuedDate", SimpleHTTPModule.Today.ToShortDateString());//
                cmd.Parameters.AddWithValue("@NoOfTrans", successcount);//
                cmd.ExecuteNonQuery();

                //bulk copy
                SqlBulkCopy tblcpyASBAMaster= new SqlBulkCopy(conn, SqlBulkCopyOptions.Default,myTrans);
                tblcpyASBAMaster.ColumnMappings.Add("ASBARef", "ASBARef");
                tblcpyASBAMaster.ColumnMappings.Add("ClientCode", "ClientCode");
                tblcpyASBAMaster.ColumnMappings.Add("BranchCode", "BranchCode");
                tblcpyASBAMaster.ColumnMappings.Add("ShareHolderAc", "ShareHolderAc");
                tblcpyASBAMaster.ColumnMappings.Add("CyCode", "CyCode");
                tblcpyASBAMaster.ColumnMappings.Add("AcType", "AcType");
                tblcpyASBAMaster.ColumnMappings.Add("DMATId", "DMATId");
                tblcpyASBAMaster.ColumnMappings.Add("ClientId", "ClientId");
                tblcpyASBAMaster.ColumnMappings.Add("BOId", "BOId");
                tblcpyASBAMaster.ColumnMappings.Add("BankCode", "BankCode");
                tblcpyASBAMaster.ColumnMappings.Add("OpenDate", "OpenDate");
                tblcpyASBAMaster.ColumnMappings.Add("EnteredBy", "EnteredBy");
                tblcpyASBAMaster.ColumnMappings.Add("ApprovedBy", "ApprovedBy");
                tblcpyASBAMaster.ColumnMappings.Add("Name", "Name");
                tblcpyASBAMaster.ColumnMappings.Add("ASBAStatus", "ASBAStatus");
                tblcpyASBAMaster.DestinationTableName = "ASBAMaster";
                tblcpyASBAMaster.WriteToServer(DtASBAMaster);

                SqlBulkCopy tblcpy = new SqlBulkCopy(conn,SqlBulkCopyOptions.Default, myTrans);
                tblcpy.ColumnMappings.Add("BatchNo", "BatchNo");
                tblcpy.ColumnMappings.Add("BranchCode", "BranchCode");
                tblcpy.ColumnMappings.Add("AcType", "AcType");
                tblcpy.ColumnMappings.Add("CyCode", "CyCode");
                tblcpy.ColumnMappings.Add("MainCode", "MainCode");
                tblcpy.ColumnMappings.Add("TranDate", "TranDate");
                tblcpy.ColumnMappings.Add("NoOfShare", "NoOfShare");
                tblcpy.ColumnMappings.Add("Name", "Name");
                tblcpy.ColumnMappings.Add("BankCode", "BankCode");
                tblcpy.ColumnMappings.Add("ThisBranch", "ThisBranch");
                tblcpy.ColumnMappings.Add("RegNo", "RegNo");
                tblcpy.ColumnMappings.Add("DMATId", "DMATId");
                tblcpy.ColumnMappings.Add("ClientId", "ClientId");
                tblcpy.ColumnMappings.Add("TakeCharge", "TakeCharge");
                tblcpy.DestinationTableName = "ASBABatApplyTran";
                tblcpy.WriteToServer(Dtimport);
                myTrans.Commit();
                Session["Imported"] = "IMPORTED :" + successcount + " Records";

            }




        }

Currently it takes about 12-15 minuets to load a excel and longer when the database uses is heavy.How can it be optimized to perform better?

P.S Feel free to roast on the coding conventions and practice with alternative/better way to it and suggestion on where i am doing wrong. Thank you.

How to get Group Id for embedding PBI Report?

I have created a Power BI Report and I am trying to integrate it into my MVC application.

I am integrating report for non-power bi users. I have taken reference from here.

In this particular example, it is getting list of reports using a group id. I want to know from where to get this group id. Or can I just get list of reports without using groupid.

 using (var client = new PowerBIClient(new Uri(ApiUrl), tokenCredentials))
            {
                // Get a list of reports.
                var reports = await client.Reports.GetReportsInGroupAsync(GroupId);
                //If group id is not present 
                // Get the first report in the group.
                var report = reports.Value.FirstOrDefault();

                if (report == null)
                {
                    return View(new EmbedConfig()
                    {
                        ErrorMessage = "Group has no reports."
                    });
                }

                // Generate Embed Token.
                var generateTokenRequestParameters = new GenerateTokenRequest(accessLevel: "view");
                var tokenResponse = await client.Reports.GenerateTokenInGroupAsync(GroupId, report.Id, generateTokenRequestParameters);

                if (tokenResponse == null)
                {
                    return View(new EmbedConfig()
                    {
                        ErrorMessage = "Failed to generate embed token."
                    });
                }

                // Generate Embed Configuration.
                var embedConfig = new EmbedConfig()
                {
                    EmbedToken = tokenResponse,
                    EmbedUrl = report.EmbedUrl,
                    Id = report.Id
                };

                return View(embedConfig);
            }

Is it possible to inject Parameters to OAuthProvider via UnityConfig? What am I missing?

I have the following constructor in my ApplicationOAuthProvider which extends from

[InjectionConstructor]
 public ApplicationOAuthProvider(UserManager<IdentityUser, Guid> userManager, RoleStore roleStore)
 {
     _userManager = userManager;
     _roleStore = roleStore;
 }

This class is to be instanciated in my Startup.Auth:

app.UseOAuthAuthorizationServer(new Microsoft.Owin.Security.OAuth.OAuthAuthorizationServerOptions
{
    TokenEndpointPath = new PathString("/oauth/token"),
    **Provider = new ApplicationOAuthProvider()**,
    AccessTokenExpireTimeSpan = TimeSpan.FromMinutes(30),
    AllowInsecureHttp = true
});
app.UseOAuthBearerAuthentication(new OAuthBearerAuthenticationOptions());

And My UnityConfig is as follows:

public static void RegisterComponents()
{
    var container = new UnityContainer();
    container.RegisterType<IUnitOfWork, DataAccess.UnitOfWork>(new HierarchicalLifetimeManager(),
    new InjectionConstructor("SiteDb")
    );
    container.RegisterType<IUserStore<IdentityUser, Guid>, UserStore>(
                    new TransientLifetimeManager());
    container.RegisterType<RoleStore>(new TransientLifetimeManager());

    DependencyResolver.SetResolver(new UnityDependencyResolver(container));
 }

Is it possible to inject to this particular class? if so, could you point me in the direction of what I might be missing?

How to ignore a specific bundle for optimization in asp.net BundleConfig

public static void RegisterBundles(BundleCollection bundles)
{
    bundles.Add(new ScriptBundle("~/bundles/jquery").Include(
                "~/Scripts/jquery-{version}.js"));

    bundles.Add(new ScriptBundle("~/bundles/angularJs").Include(
              "~/Scripts/angular.min.js"));

    bundles.Add(new ScriptBundle("~/bundles/angularComponents").Include(
                "~/Scripts/angular-route.min.js",
                "~/Scripts/angular-local-storage.min.js",
                "~/Scripts/loading-bar.min.js"));


    bundles.Add(new StyleBundle("~/Content/css").Include(
              "~/Content/bootstrap.min.css",
              "~/Content/loading-bar.min.css",
              "~/Content/font-awesome.min.css",
              "~/Content/site.css"));

    bundles.IgnoreList.Clear();
    bundles.IgnoreList.Ignore("*angular-route.min.js", OptimizationMode.Always);
    bundles.IgnoreList.Ignore("*angular-local-storage.min.js", OptimizationMode.Always);
    bundles.IgnoreList.Ignore("*loading-bar.min.js", OptimizationMode.Always);

    BundleTable.EnableOptimizations = true;
}

Here i want to remove this bundle (new ScriptBundle("~/bundles/angularComponents")) from optimization. I have tried the above way, but it doesn't ignore from optimization. Files are combined as well. Can anybody tell me how can i ignore this specific bundle list ?

Related questions

ASP.NET MVC custom routing with default route

See also questions close to this topic