public ActionResult Create(BO_inv.Transaction.GovtBooking model) { if (obj.Insert(model)) { } else { } return(RedirectToAction("Dashboard_v1")); }
public bool Insert(BO.FrontOffice.Transaction.GovtBooking model) { bool result = false; // queryString = "sp_insertguestmaster"; queryString = "insert into dbo.CH_GuestMaster (SSOID,Guesthouseid,FullName) values(12,1,vinod,)"; // queryString = "insert into dbo.CH_GuestMaster (SSOID,FullName,MobileNumber,DOB,Gender,EmailID,PostalAddress,PostalCode,City,State,BhamashahID,AadharID,OfficialDepartmentName,OfficialDivision,OfficialDesignation,OfficialExistingGradePay,OfficialGradePay,OfficialPostingPlace,OfficialState,OfficialDistrict,Personal_FirstName,Personl_MiddleName,Personal_LastName,Personal_Gender,Personal_DOB,Personal_MaritalStatus,Personal_Category,Personal_Religion,Personal_EmailID,Personal_MobileNumber,Documents)values(@SSOID, @FullName, @MobileNumber, @DOB, @Gender, @EmailID, @PostalAddress, @PostalCode, @City, @State, @BhamashahID, @AadharID, @OfficialDepartmentName, @OfficialDivision, @OfficialDesignation, @OfficialExistingGradePay, @OfficialGradePay, @OfficialPostingPlace, @OfficialState, @OfficialDistrict, @Personal_FirstName, @Personl_MiddleName, @Personal_LastName, @Personal_Gender, @Personal_DOB, @Personal_MaritalStatus, @Personal_Category, @Personal_Religion, @Personal_EmailID, @Personal_MobileNumber, @Documents)"; try { OracleConnection conn = new OracleConnection(ConnectionString); conn.Open(); OracleCommand cmd = new OracleCommand(queryString, conn); cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add(new OracleParameter("@SSOID", model.GuestID)); cmd.Parameters.Add(new OracleParameter("@SSOID", model.SSOID)); cmd.Parameters.Add(new OracleParameter("@FullName", model.FullName)); cmd.Parameters.Add(new OracleParameter("@MobileNumber", model.MobileNumber)); cmd.Parameters.Add(new OracleParameter("@DOB", model.DOB)); cmd.Parameters.Add(new OracleParameter("@Gender", model.Gender)); cmd.Parameters.Add(new OracleParameter("@EmailID", model.EmailID)); cmd.Parameters.Add(new OracleParameter("@PostalAddress", model.PostalAddress)); cmd.Parameters.Add(new OracleParameter("@PostalCode", model.PostalCode)); cmd.Parameters.Add(new OracleParameter("@City", model.City)); cmd.Parameters.Add(new OracleParameter("@State", model.State)); cmd.Parameters.Add(new OracleParameter("@AadharID", model.AadharID)); cmd.Parameters.Add(new OracleParameter("@OfficialDepartmentName", model.OfficialDepartmentName)); cmd.Parameters.Add(new OracleParameter("@OfficialDivision", model.OfficialDivision)); cmd.Parameters.Add(new OracleParameter("@OfficialDesignation", model.OfficialDesignation)); cmd.Parameters.Add(new OracleParameter("@OfficialExistingGradePay", model.OfficialExistingGradePay)); cmd.Parameters.Add(new OracleParameter("@OfficialGradePay", model.OfficialGradePay)); cmd.Parameters.Add(new OracleParameter("@OfficialPostingPlace", model.OfficialPostingPlace)); cmd.Parameters.Add(new OracleParameter("@BhamashahID", model.BhamashahID)); cmd.Parameters.Add(new OracleParameter("@OfficialState", model.OfficialState)); cmd.Parameters.Add(new OracleParameter("@OfficialDistrict", model.OfficialDistrict)); cmd.Parameters.Add(new OracleParameter("@Personal_FirstName", model.Personal_FirstName)); cmd.Parameters.Add(new OracleParameter("@Personl_MiddleName", model.Personl_MiddleName)); cmd.Parameters.Add(new OracleParameter("@Personal_LastName", model.Personal_LastName)); cmd.Parameters.Add(new OracleParameter("@Personal_Gender", model.Personal_Gender)); cmd.Parameters.Add(new OracleParameter("@Personal_DOB", model.Personal_DOB)); cmd.Parameters.Add(new OracleParameter("@Personal_MaritalStatus", model.Personal_MaritalStatus)); cmd.Parameters.Add(new OracleParameter("@Personal_Category", model.Personal_Category)); cmd.Parameters.Add(new OracleParameter("@Personal_EmailID", model.Personal_EmailID)); cmd.Parameters.Add(new OracleParameter("@Personal_Religion", model.Personal_Religion)); cmd.Parameters.Add(new OracleParameter("@Personal_MobileNumber", model.Personal_MobileNumber)); cmd.Parameters.Add(new OracleParameter("@Documents", model.Documents)); cmd.ExecuteReader(); conn.Close(); } catch (Exception ex) { // message = Common_Function.ConvertResultToFail(ex, queryString, model.User); } return(result); }
public bool Insert(BO_Inv.Transaction.GovtBooking model) { return(obj.Insert(model)); }