/// <summary> /// Deprecated Method for adding a new object to the MatrimonyDetails EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToMatrimonyDetails(MatrimonyDetail matrimonyDetail) { base.AddObject("MatrimonyDetails", matrimonyDetail); }
/// <summary> /// Create a new MatrimonyDetail object. /// </summary> /// <param name="matrimonyID">Initial value of the MatrimonyID property.</param> public static MatrimonyDetail CreateMatrimonyDetail(global::System.Int32 matrimonyID) { MatrimonyDetail matrimonyDetail = new MatrimonyDetail(); matrimonyDetail.MatrimonyID = matrimonyID; return matrimonyDetail; }
protected void btn_Submit_Click(object sender, EventArgs e) { 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(); int? intldt = ObjEntity.MatrimonyDetails.Max(u => (int?)u.MatrimonyID); if (intldt == null) { objMatrim.MatrimonyID = 1; } else { int intldt2 = ObjEntity.MatrimonyDetails.Max(u => u.MatrimonyID); objMatrim.MatrimonyID = intldt2 + 1; } objMatrim.ProfileFor = Convert.ToString(Session["ProfileFor"]); 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"]); if (blnNoStateCity) { objMatrim.StateID = 999; objMatrim.CityID = 999; objMatrim.StateName = TxtState.Text.Trim(); objMatrim.CityName = TxtCity.Text.Trim(); } else { objMatrim.StateID = int.Parse(DDL_State.SelectedValue); objMatrim.CityID = int.Parse(DDL_City.SelectedValue); objMatrim.StateName = Convert.ToString(DDL_State.SelectedItem); objMatrim.CityName = ""; } objMatrim.ReligionID = int.Parse(Session["SessionReligion"].ToString()); objMatrim.CasteID = int.Parse(Session["SessionCaste"].ToString()); //objMatrim.SubCasteID = 4; //objMatrim.SubCasteID = int.Parse(DDL_SubCaste.SelectedValue); if (blnNoSubCaste) { objMatrim.SubCasteID = 999; objMatrim.SubcasteName = Txt_SubCaste.Text.Trim(); } else { objMatrim.SubCasteID = int.Parse(DDL_SubCaste.SelectedValue); objMatrim.SubcasteName = ""; } //objMatrim.GothraID = 1; if (blnNoSubCaste) { objMatrim.GothraID = 999; objMatrim.GothraName = Txt_Gothram.Text.Trim(); } else { objMatrim.GothraID = int.Parse(DDl_Gothra.SelectedValue); objMatrim.GothraName = ""; } 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 = "W"; 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 = DDL_NoOfChild.SelectedValue.ToString(); if (Rbtn_ChildLiving1.Checked == true) objMatrim.LivingWith = "Y"; else objMatrim.LivingWith = "N"; if (Rbtn_Caste1.Checked == true) objMatrim.SameCommunity = "Y"; else objMatrim.SameCommunity = "N"; objMatrim.DescriptionInfo = Txt_Desc.Text; objMatrim.ActiveInd = "N"; objMatrim.CreatedDate = DateTime.Parse(System.DateTime.Now.ToString()); objMatrim.UpdatedDate = DateTime.Parse(System.DateTime.Now.ToString()); ObjEntity.AddToMatrimonyDetails(objMatrim); ObjEntity.SaveChanges(); PhysicalAttr objphysical = new PhysicalAttr(); objphysical.MatrimonyID = objMatrim.MatrimonyID; objphysical.HeightAttr = Convert.ToInt32(Txt_Height.Text); objphysical.WeightAttr = Convert.ToInt32(Txt_Weight.Text); string ObjBodytype = "A"; if (Rbtn_BodyType1.Checked == true) ObjBodytype = "A"; else if (Rbtn_BodyType2.Checked == true) ObjBodytype = "T"; else if (Rbtn_BodyType3.Checked == true) ObjBodytype = "S"; else if (Rbtn_BodyType4.Checked == true) ObjBodytype = "H"; objphysical.BodyType = ObjBodytype; string strComplexion = "F"; if (Rbtn_Complextion1.Checked == true) strComplexion = "F"; else if (Rbtn_Complextion2.Checked == true) strComplexion = "V"; else if (Rbtn_Complextion3.Checked == true) strComplexion = "W"; else if (Rbtn_Complextion4.Checked == true) strComplexion = "B"; else if (Rbtn_Complextion5.Checked == true) strComplexion = "D"; objphysical.Complexion = strComplexion; string strPhyStatus = "N"; if (Rbtn_PhysicalStatus1.Checked == true) strPhyStatus = "N"; else if (Rbtn_PhysicalStatus2.Checked == true) strPhyStatus = "P"; objphysical.PhysicalStatus = strPhyStatus; ObjEntity.AddToPhysicalAttrs(objphysical); ObjEntity.SaveChanges(); EduDetail ObjEduDetail = new EduDetail(); ObjEduDetail.MatrimonyID = objMatrim.MatrimonyID; ObjEduDetail.EducationID = int.Parse(DDL_HighestEdu.SelectedValue); ObjEduDetail.OccupID = int.Parse(DDL_Occupation.SelectedValue); String strEmployedIn = "G"; if (Rbtn_EmpIn1.Checked == true) strEmployedIn = "G"; else if (Rbtn_EmpIn2.Checked == true) strEmployedIn = "P"; else if (Rbtn_EmpIn3.Checked == true) strEmployedIn = "B"; else if (Rbtn_EmpIn4.Checked == true) strEmployedIn = "S"; else if (Rbtn_EmpIn5.Checked == true) strEmployedIn = "D"; ObjEduDetail.EmployedIn = strEmployedIn; string objIncometype = "M"; if (Rbtn_IncomeType1.Checked == true) objIncometype = "M"; else if (Rbtn_IncomeType2.Checked == true) objIncometype = "A"; 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 = objMatrim.MatrimonyID; string ObjFoodtype = "Non-Vegetarian"; if (Rbtn_FoodType1.Checked == true) ObjFoodtype = "N"; else if (Rbtn_FoodType2.Checked == true) ObjFoodtype = "V"; else if (Rbtn_FoodType3.Checked == true) ObjFoodtype = "E"; objhabits.Food = ObjFoodtype; string objSmoking = "No"; if (Rbtn_Smoking1.Checked == true) objSmoking = "N"; else if (Rbtn_Smoking2.Checked == true) objSmoking = "Y"; else if (Rbtn_Smoking3.Checked == true) objSmoking = "O"; objhabits.Smoking = objSmoking; string objDrinking = "N"; if (Rbtn_Drinking1.Checked == true) objDrinking = "N"; else if (Rbtn_Drinking2.Checked == true) objDrinking = "Y"; else if (Rbtn_Drinking3.Checked == true) objDrinking = "O"; objhabits.Drinking = objDrinking; ObjEntity.AddToHabits(objhabits); ObjEntity.SaveChanges(); AstrologicalInfo objastrological = new AstrologicalInfo(); objastrological.MatrimonyID = objMatrim.MatrimonyID; string objdosham = "N"; if (Rbtn_Chevvai1.Checked == true) objdosham = "N"; else if (Rbtn_Chevvai2.Checked == true) objdosham = "Y"; else if (Rbtn_Chevvai3.Checked == true) objdosham = "D"; 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 = objMatrim.MatrimonyID; string ObjFamilystatus = "Middle Class"; if (Rbtn_FamilyStatus1.Checked == true) ObjFamilystatus = "M"; else if (Rbtn_FamilyStatus2.Checked == true) ObjFamilystatus = "U"; else if (Rbtn_FamilyStatus3.Checked == true) ObjFamilystatus = "R"; else if (Rbtn_FamilyStatus4.Checked == true) ObjFamilystatus = "A"; objfamily.FamilyStatus = ObjFamilystatus; string ObjFamilyType = "S"; if (Rbtn_FamilyType1.Checked == true) ObjFamilystatus = "S"; else if (Rbtn_FamilyType2.Checked == true) ObjFamilystatus = "N"; objfamily.FamilyType = ObjFamilyType; string ObjFamilyValue = "O"; if (Rbtn_FamilyValue1.Checked == true) ObjFamilyValue = "O"; else if (Rbtn_FamilyValue2.Checked == true) ObjFamilyValue = "T"; else if (Rbtn_FamilyValue3.Checked == true) ObjFamilyValue = "M"; else if (Rbtn_FamilyValue4.Checked == true) ObjFamilyValue = "L"; objfamily.FamilyValues = ObjFamilyValue; ObjEntity.AddToFamilies(objfamily); ObjEntity.SaveChanges(); 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(); Response.Redirect("Home.aspx"); } } } }
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(); // First SaveChange method. MatrimonyDetail objMatrim = new MatrimonyDetail(); objMatrim.MatrimonyID = 1; objMatrim.Name = Convert.ToString(Session["Sessionname"]); objMatrim.DOB = Convert.ToDateTime(Session["SessionDOB"]); 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 = 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(); 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(); //// 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(); } } } }
protected void CreatePjt_Click(object sender, EventArgs e) { MatrimonyDetail objMatri = new MatrimonyDetail(); //LblMailDesc.Text = Txt_Desc.Text; //objMatri.DescriptionInfo = Txt_Desc.Text; }
protected void CloseBtn_Click(object sender, EventArgs e) { MatrimonyDetail objMatri = new MatrimonyDetail(); LblMailDesc.Text = objMatri.DescriptionInfo; }