How to insert "Multiple Field Value"in Single Column in MVC4

Sneha K

11y1.1k.NET

Please leave reading the codings part. I mentioned my issue in last. Why i include my DB and Codings means suppose if you didn't understand my issue you can refer this (i.e) what i did from the Starting Itself.

In my project i have Customer Master. It contain 16 fields like

1) Customer ID2) Customer Name 3) Alias 4) Customer Type 5) Street 6) Location 7) Area 8) City 9) Stat 10) Country 11 Tin No 12 Cst No 13 Service Tax No 14 Excise Reg No 15 Pan No 16) Cin No

My CustomerMaster Tables are

Customer
CustomerID Primary key Uniqueidentifier not null,
Display Name Varchar(100) null,
Print Name Varchar(100) null,
CustomerType ID Uniqueidentifier null.

Customer Address
CustomerAddressID Primary key Uniqueidentifier not null,
CustomerID Uniqueidentifier null,
AddressID Uniqueidentifier null.

Address
AddressID Primary key Uniqueidentifier not null,AddressTypeID Uniqueidentifier null,
DisplayName Varchar(100) null,
SalutationID Uniqueidentifier null,
PrintName Varchar(100) null,
SimpleMode bit null,
DetailMode bit null,
Street Varchar(100) null,
Location Varchar(100) null,
Place Varchar(100) null,
AreadID Uniqueidentifier null,
Pincode Varchar(100) null.

Area

AreaID Primary key Uniqueidentifier not null,

DisplayName Varchar(100) null,
PrintName Varchar(100) null,
CityID Uniqueidentifier null.

Salutation

SalutationID Primary key Uniqueidentifier not null,
DisplayName Varchar(100) null,
PrintName Varchar(100) null

City
CityID Primary key Uniqueidentifier not null,
DisplayName Varchar(100) null,
PrintName Varchar(100) null ,
StateID Uniqueidentifier null.

State

StateId Primary key Uniqueidentifier not null,
DisplayName Varchar(100) null ,
PrintName Varchar(100) null ,
CountryID Uniqueidentifier null.

Country
CountryID Primary key Uniqueidentifier not null,
DisplayName Varchar(100) null ,
PrintName Varchar(100) null.

CustomerTaxInfo

CustomerTaxInfoID Primary key Uniqueidentifier not null,

CustomerID Uniqueidentifier null,
TaxInfoReference Varchar(100) null ,
TaxInfoID Uniqueidentifier null,

Taxfield TaxFieldID PrimaryKey Uniqueidentifier not null,
DisplayName Varchar(100) null ,
PrintName Varchar(100) null.

TaxInfo

TaxInfoID PrimaryKey Uniqueidentifier not null,
DisplayName Varchar(100) null ,
PrintName Varchar(100) null.

TaxInfoTaxField

TaxInfoTaxFieldID PrimaryKey Uniqueidentifier not null,
TaxInfoID Uniqueidentifier null,,
TaxFieldID Uniqueidentifier null,
FieldValue big int,

Here CustomerType , Area, Salutation, City, State ,Country all are Separate View. I referred these Id's to Main View(Customer View) . If I connect my DB with Vb Express 2012 for Database Connection . Then I create the EDMX File. So it will automatically create Separate view for each Table. So I decided to bring all the Fields in Single View . So I Used “Code First approach” and “ViewModel”. I Created the Model and ViewModel .

My ViewModel

using System;

using System.Collections.Generic;

using System.Data.Entity;

using System.Linq;

using System.Web;

namespace Sample_Customer.Models

{

public class CustomerViewModel

{

public System.Guid CustomerID { get; set; }

public string CustomerName { get; set; }

public System.Guid SalutationID { get; set; }

public string Alias { get; set; }

public System.Guid CustomerTypeID { get; set; }

public string CustomerType { get; set; }

public System.Guid AddressTypeID { get; set; }

public string AddressType { get; set; }

public System.Guid CustomerAddressID { get; set; }

public System.Guid AddressID { get; set; }

public string Street { get; set; }

public string Location { get; set; }

public string Place { get; set; }

public Nullable AreaID { get; set; }

public string Area { get; set; }

public Nullable CityID{ get; set; }

public string City { get; set; }

public Nullable StateID{ get; set; }

public string State { get; set; }

public Nullable CountryID{ get; set; }

public string Country { get; set; }

public string PinCode { get; set; }

public System.Guid TaxInfoID { get; set; }

public Nullable TaxFiledID { get; set; }

public System.Guid CustomerTaxInfo { get; set; }

public string TinNo { get; set; }

public string CstNo { get; set; }

public string ExciseRegNo { get; set; }

public string PanNo { get; set; }

public string ServiceTaxNo { get; set; }

public string CinNo { get; set; }

}

public class VisitorsEntities1 : DbContext

{

public DbSet Customer { get; set; }

public DbSet CustomerType { get; set; }

public DbSet CustomerAddress { get; set; }

public DbSet Address { get; set; }

public DbSet AddressType { get; set; }

public DbSet Salutation { get; set; }

public DbSetArea{ get; set; }

public DbSet City { get; set; }

public DbSet State { get; set; }

public DbSet Country { get; set; }

public DbSet CustomerContact { get; set; }

public DbSet Contact { get; set; }

public DbSet ContactType { get; set; }

public DbSet CustomerTaxInfo { get; set; }

public DbSet TaxInfo { get; set; }

public DbSet TaxField { get; set; }

public DbSet TaxInfoTaxFiled { get; set; }

}

And My Controller

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using Sample_Customer.Models;

namespace Sample_Customer.Controllers

{

public class CustomerController : Controller

{

VisitorsEntities1 db = new VisitorsEntities1();

// GET: /Customer/

public ActionResult Index()

{

return View();

}

public ActionResult Create()

{

VisitorsEntities1 db = new VisitorsEntities1();

ViewBag.Country = new SelectList(db.Country, "CountryID", "DisplayName","PrintName");

ViewBag.State = new SelectList(db.State, "StateID", "DisplayName", "PrintName");

ViewBag.City = new SelectList(db.City, "CityID", "DisplayName", "PrintName");

ViewBag.Area = new SelectList(db.Area, "AreaID", "DisplayName", "PrintName");

return View();

[HttpPost

public ActionResult Create(CustomerViewModel viewmodel) {

ViewBag.Country = new SelectList(db.Country, "CountryID", "DisplayName","PrintName");

ViewBag.State = new SelectList(db.State, "StateID", "DisplayName", "PrintName");

ViewBag.City = new SelectList(db.City, "CityID", "DisplayName", "PrintName");

ViewBag.Area = new SelectList(db.Area, "AreaID", "DisplayName", "PrintName");

var Customerobj = new Customer()

{

CustomerID= Guid .NewGuid (),

DisplayName = viewmodel.CustomerName,

PrintName = viewmodel .CustomerName,

CustomerType =viewmodel.CustomerTypeID,

};

var CustomerTypeobj = new CustomerType()

{

CustomerTypeID= Guid.NewGuid(),

DisplayName = viewmodel.CustomerType,

PrintName= viewmodel.CustomerType

};

var CustomerAddressobj = new CustomerAddress()

{

CustomerAddressID= Guid.NewGuid(),

CustomerID= viewmodel.CustomerID,

AddressID= viewmodel.AddressID

};

var Addressobj = new Address()

{

AddressID = Guid.NewGuid(),

AddressTypeID = viewmodel.AddressTypeID,

DisplayName= viewmodel.CustomerName,

Salutation= viewmodel.Alias,

PrintName= viewmodel.CustomerName,

Street=viewmodel.Street,

Location= viewmodel.Location,

Place= viewmodel.Place,

Area = viewmodel.AreaID,

PinCode= viewmodel.PinCode

};

while Saving the data in Database using Code First approach is working fine upto Address.That is It saving the data up to Address details in DB is working Fine. But I got a problem while Saving the Tax details.In my view I have Six Fields like TinNo , CstNo, PanNo, ExciseRegNo, ServiceTxNo, CinNo.Each one have Default value which is saved in TaxField Table.

Eg TinNo = FD713788-B5AE-49FF-8B2C-F311B9CB0CC4

CstNo = 64B512E7-46AE-4989-A049-A446118099C4

CinNo =59A2449A-C5C6-45B5-AA00-F535D83AD48B

Same as like that other field PanNo, ExciseRegNo, ServiceTxNo contain Default Value .

Suppose now I am going to save one customer Details in CustomerMaster view and enter the TinNo ,CstNo, PanNo, ExciseRegNo, ServiceTxNo, CinNo, means it have to save the values(Which is entered in the Field of TinNo in the View) in FieldValue and their ID ( eg TinNo = FD713788-B5AE-49FF-8B2C-F311B9CB0CC4) in TaxFieldID of TaxInfoTaxField Table.That is I need to save those six Field in same column not in same row and same cell. Suppose if I enter the TinNo means it have to save the value in FieldValue and ID in TaxFieldID. Then I enter the CstNo it will automatically go and create the new row and have to save the Value and ID in the FieldValue and TaxFieldID. So for each Customer it will create 6 rows automatically while Saving TaxDetails. How to do this MVC4 ?

Thanks..

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Saineshwar Bageri11y ago
Accepted answer
In this way you want to save data then create another table and Use For or foreach loop to save data in that table.

0
Saineshwar Bageri11y ago
check out this way work for you else write conditional statement .

[HttpPost]
public ActionResult Index(totalviewmodel TM)
{

Type type = typeof(City); // City class name
PropertyInfo[] properties = type.GetProperties();
foreach (PropertyInfo property in properties)
{
City tv = new City(); //create object of class which you want to save

tv.CityID = (int)property.GetValue(TM.City.CityID, null); // Assiging value
tv.CityName = (string)property.GetValue(TM.City.CityName, null); // Assiging value

tv.City.Add(City);
tv.SaveChanges();
}

return View();
}
0

Sneha K11y ago

TaxField table

TaxInfoTaxfieldTable

MyView

TinNo :

CstNo :

CinNo :

PanNo :

ServiceTaxNo :

ExciseRegNo :

Need to Save Format in TaxInfoTaxFieldTable

TinNo = FD713788-B5AE-49FF-8B2C-F311B9CB0CC4

CstNo = 64B512E7-46AE-4989-A049-A446118099C4

CinNo =59A2449A-C5C6-45B5-AA00-F535D83AD48B

TaxInfoTaxFieldID	TaxFieldID	FieldValue
NewGuid()	TinNoID Eg(FD713788-B5AE-49FF-8B2C-F311B9CB0CC4)	TinNo
NewGuid()	CstNoID Eg(64B512E7-46AE-4989-A049-A446118099C4 )	CstNo
NewGuid()	CinNoEg(59A2449A-C5C6-45B5-AA00-F535D83AD48B)	CinNo
NewGuid()	ServiceTaxNo Eg(2F405521-06A0-427C-B9A3-56B8931CFC57)	ServiceTaxNo

My Model

public partial class TaxInfoTaxFiled

{

public System.Guid TaxInfoTaxFieldID { get; set; }

public NullableGuid> TaxInfoID { get; set; }

public NullableGuid> TaxFieldID { get; set; }

public NullableGuid> FieldTypeID { get; set; }

public string FieldValue { get; set; }

}

public partial class TaxField

{

public System.Guid TaxFieldID { get; set; }

public string DisplayName { get; set; }

public string PrintName { get; set; }

}

My ViewModel

public class TaxViewModel1

{

public System.Guid TaxInfoTaxFieldID { get; set; }

public System.Guid TaxInfoID { get; set; }

public NullableGuid> TaxFiledID { get; set; }

public string TinNo { get; set; }

public string CstNo { get; set; }

public string ExciseRegNo { get; set; }

public string PanNo { get; set; }

public string ServiceTaxNo { get; set; }

public string CinNo { get; set; }

}

public class VisitorsEntities1 : DbContext

{

public DbSet TaxField { get; set; }

public DbSet TaxInfo { get; set; }

public DbSet TaxInfoTaxFiled { get; set; }

}

My Controller

[HttpPost]

public ActionResult Index(TaxViewModel1 TVM)

{

Type type = typeof(TaxField);

PropertyInfo[] Info = new TaxInfoTaxField().GetType().GetProperties();

foreach (TaxInfoTaxField property in properties)

{

var Value = property.GetValue(TVM.TinNo, null);

var Value1 = property.GetValue(TVM.CstNo, null);

}

return View(Tax);

}

Sir In this Code of line we get the Properties of TaxField and Pass it to TaxinfoTaxField Table

Type type = typeof(TaxField);

PropertyInfo[] Info = new TaxInfoTaxField().GetType().GetProperties();

And here we assigning the Value to the Variable. But how to assign the value to the Column .

And How to do save the Value in FieldValue and ID in TaxFieldID of TaxInfoTaxField Table in the above format which I mentioned. Please Correct my Controller Code . I am very very new to MVC . so only I struggling for this Small Concepts. Please correct my Controller Code and help me to save the Values in the TaxInfoTaxField table. And if you have a times means please explain me the Logic you used in Controller.

Sneha K11y ago
ok Sir lets i have a try If suppose I got any error means I will inform you
0
Saineshwar Bageri11y ago
Create a new Model with Properties which you required for adding in that table.
For Me it is city.

public class totalviewmodel
{
public int CountryID { get; set; }
public string CountryName { get; set; }
public City City { get; set; }
}

public class City
{
public int CityID { get; set; }
public string CityName { get; set; }
}

In view i have used model in below way.

@Html.LabelFor(model => model.CountryName)

@Html.EditorFor(model => model.CountryName)
@Html.ValidationMessageFor(model => model.CountryName)

@Html.LabelFor(model => model.City.CityName)

@Html.EditorFor(model => model.City.CityName)
@Html.ValidationMessageFor(model => model.City.CityName)

After that in post you need to do like this your View

[HttpPost]
public ActionResult Index(totalviewmodel TM)
{

Type type = typeof(City); // City class name
PropertyInfo[] properties = type.GetProperties();
foreach (PropertyInfo property in properties)
{
var value = property.GetValue(TM.City, null); // TM viewmodel Name
}

return View();
}

0
Sneha K11y ago

This Is my TaxField Table In this Table Each one Contain Default Value eg
Eg TinNo = FD713788-B5AE-49FF-8B2C-F311B9CB0CC4
  Now I want to insert the Value of TinNo in FieldValue and Id of TinNo in TaxFieldID of TaxInfoTaxField Table. So i decided to create Datatable in the below format.

CstNo:
TinNo:

Now I want to pass the ID
FD713788-B5AE-49FF-8B2C-F311B9CB0CC4 for Label TinNo
for(i=0 to RowCount-1)
{
TaxFieldID= row(i).cell("HERE How can I pass the ID of TinNo"). value
FieldValue= row(i).cell("Value").Value
i++
}
TaxFieldID= row(i).cell("HERE How can I pass the ID of TinNo"). value
Here how can i Pass that ID TinNo = FD713788-B5AE-49FF-8B2C-F311B9CB0CC4 to   row(i).cell("HERE How can I pass the ID of TinNo"). value this place only I got confusion can you explain me how to do this using for loop.

Thanks for your reply dude..
0
Sneha K11y ago
Yes exactly I have Two column in my Table TaxFieldId and FieldValue the values of each field TinNo, CstNo which are entered in the view have to Save in FieldValue and the ID of TinNo Eg TinNo = FD713788-B5AE-49FF-8B2C-F311B9CB0CC4 is need to save in TaxFieldId of Table. You suggest me to use Foreach loop. I accepted . But i donno how to do that?
0