/// <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;
}
