/// <summary>
/// Create a new PhysicalAttr object.
/// </summary>
/// <param name="matrimonyID">Initial value of the MatrimonyID property.</param>
public static PhysicalAttr CreatePhysicalAttr(global::System.Int32 matrimonyID)
{
PhysicalAttr physicalAttr = new PhysicalAttr();
physicalAttr.MatrimonyID = matrimonyID;
return physicalAttr;
}
/// <summary>
/// Deprecated Method for adding a new object to the PhysicalAttrs EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToPhysicalAttrs(PhysicalAttr physicalAttr)
{
base.AddObject("PhysicalAttrs", physicalAttr);
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
//SqlTransaction Transaction;
//con.Open();
//Transaction = con.BeginTransaction();
/* try
{
new SqlCommand("INSERT INTO Transact VALUES ('" +
* Convert.ToString(Session["Sessionname"]) + "','" +
* Convert.ToString(Session["SessionDOB"]) + "','" +
* Convert.ToString(Session["SessionGender"]) + "','" +
* Convert.ToString(Session["SessionMobile"]) + "','" +
* Convert.ToString(Session["SessionCountry"]) + "','" +
* DDL_State.SelectedItem + "','" + DDL_City.SelectedItem + "','" +
* Convert.ToString(Session["SessionReligion"]) + "','" +
* Convert.ToString(Session["SessionCaste"]) + "','" +
* DDL_SubCaste.SelectedItem + "','" + Txt_Gothram.Text + "','" +
* Convert.ToString(Session["SessionEmail"]) + "','" + Rbtn_PhysicalStatus.SelectedValue + "','" +
* Txt_Desc.Text + "');", con, Transaction).ExecuteNonQuery();
new SqlCommand("INSERT INTO EduDetails values ('" + Txt_Height.Text + "','" + DDL_Occupation.SelectedItem + "','" + Rbtn_EmpIn.SelectedValue + "','" + Rbtn_IncomeType.SelectedValue + "','" + DDL_IncomeType.SelectedItem + "','" + Txt_Amount.Text + "');", con, Transaction).ExecuteNonQuery();
new SqlCommand("INSERT INTO Habit values('" + Rbtn_Food.SelectedValue + "','" + Rbtn_Smoking.SelectedValue + "','" + Rbtn_Drinking.SelectedValue + "');", con, Transaction).ExecuteNonQuery();
new SqlCommand("INSERT INTO AstrologicalInfo values('" + Rbtn_Dhosam.SelectedValue + "','" + DDL_Star.SelectedItem + "','" + DDL_Moon.SelectedItem + "');", con, Transaction).ExecuteNonQuery();
new SqlCommand("insert into Family values('" + Rbtn_familystatus.SelectedValue + "','" + Rbtn_FamType.SelectedValue + "','" + Rbtn_FamValue.SelectedValue + "');", con, Transaction).ExecuteNonQuery();
Transaction.Commit();
}
catch
{
Transaction.Rollback();
}
con.Close();*/
using (TransactionScope ts = new TransactionScope())
{
try
{
//using (DataContext contextObject = new DataContext(ConnectionString))
//{
// Open the contextObject connection state explicitly
ObjEntity.Connection.Open();
string hh = Session["SessionDOB"].ToString();
// //First SaveChange method.
MatrimonyDetail objMatrim = new MatrimonyDetail();
objMatrim.MatrimonyID = 1;
objMatrim.Name = Convert.ToString(Session["Sessionname"]);
objMatrim.DOB = DateTime.Parse(hh);
objMatrim.Gender = Convert.ToString(Session["SessionGender"]);
objMatrim.CountryID = int.Parse(Session["SessionCountry"].ToString());
objMatrim.MobileNo = Convert.ToString(Session["SessionMobile"]);
objMatrim.StateID = int.Parse(DDL_State.SelectedValue);
objMatrim.CityID = int.Parse(DDL_City.SelectedValue);
objMatrim.ReligionID = int.Parse(Session["SessionReligion"].ToString());
objMatrim.CasteID = int.Parse(Session["SessionCaste"].ToString());
objMatrim.SubCasteID = 6;
//objMatrim.SubCasteID = int.Parse(DDL_SubCaste.SelectedValue);
objMatrim.GothraID = 1;
objMatrim.Email = Convert.ToString(Session["SessionEmail"]);
objMatrim.LoginPwd = Convert.ToString(Session["SessionPwd"]);
string strMaritalStatus = "U";
if (Rbtn_MartialStatus1.Checked == true)
strMaritalStatus = "U";
else if (Rbtn_MartialStatus2.Checked == true)
strMaritalStatus = "M";
else if (Rbtn_MartialStatus3.Checked == true)
strMaritalStatus = "D";
else if (Rbtn_MartialStatus4.Checked == true)
strMaritalStatus = "A";
objMatrim.MaritalStatus = strMaritalStatus;
//objMatrim.TongueID = int.Parse(Session["SessionMotherTon"].ToString());
//objMatrim.NoOfChild = DDL_NoOfChild.SelectedValue.ToString();
objMatrim.NoOfChild = "on";
if (Rbtn_ChildLiving1.Checked == true)
objMatrim.LivingWith = "Y";
else
objMatrim.LivingWith = "N";
objMatrim.DescriptionInfo = Txt_Desc.Text;
objMatrim.ActiveInd = "N";
objMatrim.CreatedDate = System.DateTime.Now;
objMatrim.UpdatedDate = System.DateTime.Now;
ObjEntity.AddToMatrimonyDetails(objMatrim);
ObjEntity.SaveChanges();
PhysicalAttr Objphysical = new PhysicalAttr();
Objphysical.MatrimonyID = 1;
Objphysical.HeightAttr = Convert.ToInt32(Txt_Height.Text);
Objphysical.WeightAttr = Convert.ToInt32(Txt_Weight.Text);
string ObjBodytype = "Average";
if (Rbtn_BodyType1.Checked == true)
ObjBodytype = "Average";
else if (Rbtn_BodyType2.Checked == true)
ObjBodytype = "Athletic";
else if (Rbtn_BodyType3.Checked == true)
ObjBodytype = "Slim";
else if (Rbtn_BodyType4.Checked == true)
ObjBodytype = "Heavy";
Objphysical.BodyType = ObjBodytype;
string ObjComplexion = "Fair";
if (Rbtn_Complextion1.Checked == true)
ObjComplexion = "Fair";
else if (Rbtn_Complextion2.Checked == true)
ObjComplexion = "Very Fair";
else if (Rbtn_Complextion3.Checked == true)
ObjComplexion = "Wheatish";
else if (Rbtn_Complextion4.Checked == true)
ObjComplexion = "Wheatish-Brown";
else if (Rbtn_Complextion5.Checked == true)
ObjComplexion = "Dark";
Objphysical.Complexion = ObjComplexion;
string ObjPhyStatus = "Normal";
if (Rbtn_PhysicalStatus1.Checked == true)
ObjPhyStatus = "Normal";
else if (Rbtn_PhysicalStatus2.Checked == true)
ObjPhyStatus = "Physical Status";
Objphysical.PhysicalStatus = ObjPhyStatus;
ObjEntity.AddToPhysicalAttrs(Objphysical);
ObjEntity.SaveChanges();
EduDetail ObjEduDetail = new EduDetail();
ObjEduDetail.MatrimonyID=1;
ObjEduDetail.EducationID=int.Parse(DDL_HighestEdu.SelectedValue);
ObjEduDetail.OccupID=int.Parse(DDL_Occupation.SelectedValue);
String objemployedIn="Goverment";
if (Rbtn_EmpIn1.Checked == true)
objemployedIn="Goverment";
else if (Rbtn_EmpIn2.Checked == true)
objemployedIn="Private";
else if (Rbtn_EmpIn3.Checked == true)
objemployedIn="Business";
else if (Rbtn_EmpIn4.Checked == true)
objemployedIn="Self-Employed";
else if (Rbtn_EmpIn5.Checked == true)
objemployedIn="Defence";
ObjEduDetail.EmployedIn=objemployedIn;
string objIncometype="Monthly Income";
if (Rbtn_IncomeType1.Checked == true)
objIncometype="Monthly Income";
else if (Rbtn_IncomeType2.Checked == true)
objIncometype="Annual Income";
ObjEduDetail.IncomeType=objIncometype;
ObjEduDetail.CurrID=int.Parse(DDL_IncomeType.SelectedValue);
ObjEduDetail.Income = Convert.ToInt32(Txt_Amount.Text);
ObjEntity.AddToEduDetails(ObjEduDetail);
ObjEntity.SaveChanges();
Habit objhabits = new Habit();
objhabits.MatrimonyID = 1;
string ObjFoodtype = "Non-Vegetarian";
if (Rbtn_FoodType1.Checked == true)
ObjFoodtype = "Non-Vegetarian";
else if (Rbtn_FoodType2.Checked == true)
ObjFoodtype = "Vegetarian";
else if (Rbtn_FoodType3.Checked == true)
ObjFoodtype = "Eggetarian";
objhabits.Food = ObjFoodtype;
string objSmoking = "No";
if (Rbtn_Smoking1.Checked == true)
objSmoking = "No";
else if (Rbtn_Smoking2.Checked == true)
objSmoking = "Yes";
else if (Rbtn_Smoking3.Checked == true)
objSmoking = "Occasionally";
objhabits.Smoking = objSmoking;
string objDrinking = "No";
if (Rbtn_Drinking1.Checked == true)
objDrinking = "No";
else if (Rbtn_Drinking2.Checked == true)
objDrinking = "Yes";
else if (Rbtn_Drinking3.Checked == true)
objDrinking = "Occasionally";
objhabits.Drinking = objDrinking;
ObjEntity.AddToHabits(objhabits);
ObjEntity.SaveChanges();
AstrologicalInfo objastrological = new AstrologicalInfo();
objastrological.MatrimonyID = 1;
string objdosham="No";
if (Rbtn_Chevvai1.Checked == true)
objdosham="No";
else if (Rbtn_Chevvai2.Checked == true)
objdosham="Yes";
else if (Rbtn_Chevvai3.Checked == true)
objdosham="Dont Know";
objastrological.Dosham = objdosham;
objastrological.StarID = int.Parse(DDL_Star.SelectedValue);
objastrological.RaasiID = int.Parse(DDL_Moon.SelectedValue);
ObjEntity.AddToAstrologicalInfoes(objastrological);
ObjEntity.SaveChanges();
Family objfamily = new Family();
objfamily.MatrimonyID = 1;
string ObjFamilystatus = "Middle Class";
if (Rbtn_FamilyStatus1.Checked == true)
ObjFamilystatus = "Middle Class";
else if (Rbtn_FamilyStatus2.Checked == true)
ObjFamilystatus = "Upper-Middle Class";
else if (Rbtn_FamilyStatus3.Checked == true)
ObjFamilystatus = "Rich";
else if (Rbtn_FamilyStatus4.Checked == true)
ObjFamilystatus = "Affluent";
objfamily.FamilyStatus = ObjFamilystatus;
string ObjFamilyType = "Single";
if (Rbtn_FamilyType1.Checked == true)
ObjFamilystatus = "Single";
else if (Rbtn_FamilyType2.Checked == true)
ObjFamilystatus = "Nuclear";
objfamily.FamilyType = ObjFamilyType;
string ObjFamilyValue = "Orthodox";
if (Rbtn_FamilyValue1.Checked == true)
ObjFamilyValue = "Orthodox";
else if (Rbtn_FamilyValue2.Checked == true)
ObjFamilyValue = "Traditional";
else if (Rbtn_FamilyValue3.Checked == true)
ObjFamilyValue = "Moderate";
else if (Rbtn_FamilyValue4.Checked == true)
ObjFamilyValue = "Liberal";
objfamily.FamilyValues = ObjFamilyValue;
ObjEntity.AddToFamilies(objfamily);
ObjEntity.SaveChanges();
//// Second SaveChange method.
//....Codes for 2nd table.....
//contextObject.SaveChanges();
//// Third SaveChange method.
//....Codes for 3rd table.....
//contextObject.SaveChanges();
// If execution reaches here, it indicates the successfull completion of all three save operation. hence comit the transaction.
ts.Complete();
//}
}
catch (Exception ex)
{
// If any excption is caught, roll back the entire transaction and ends the transaction scope
ts.Dispose();
}
finally
{
// Close the opened connection
if (ObjEntity.Connection.State == ConnectionState.Open)
{
ObjEntity.Connection.Close();
}
}
}
}