public long addCustomerCoinfo(SqlConnection conn, SqlTransaction trans, customer customer) { ConnectionDao connectionDao = new ConnectionDao(); string returnString = IdProConstants.SUCCESS; SqlCommand cmd = null; SqlDataReader rs = null; long Customer_ID = 0; string query = "INSERT INTO Customer([First_name],[Last_name],[DOB],[SSN],[Customer_Type]) VALUES (@First_name,@Last_name,@DOB,@SSN,@Customer_Type);SELECT Customer_ID=scope_identity();"; try { cmd = connectionDao.getSqlCommand(query, conn, trans); SqlParameter param1 = new SqlParameter(); param1.ParameterName = "@First_name"; param1.Value = customer.cofirstname; cmd.Parameters.Add(param1); SqlParameter param2 = new SqlParameter(); param2.ParameterName = "@Last_name"; param2.Value = customer.colastname; cmd.Parameters.Add(param2); SqlParameter param3 = new SqlParameter(); param3.ParameterName = "@DOB"; param3.Value = customer.Codob; cmd.Parameters.Add(param3); SqlParameter param4 = new SqlParameter(); param4.ParameterName = "@SSN"; param4.Value = customer.cossn; cmd.Parameters.Add(param4); SqlParameter param16 = new SqlParameter(); param16.ParameterName = "@Customer_Type"; param16.Value = "Secondary"; cmd.Parameters.Add(param16); rs = cmd.ExecuteReader(); if (rs.Read()) { Customer_ID = Int32.Parse(rs["Customer_ID"].ToString()); } } catch (Exception exception) { System.Diagnostics.Trace.WriteLine("[CustomerDAO:addCustomerBasicInfo] Exception " + exception.StackTrace); } finally { connectionDao.closeDabaseEntities(cmd, rs); } // return returnString; return Customer_ID; }
public long addCustomerBasicInfo(SqlConnection conn, SqlTransaction trans, customer customer) { string strdrop = ""; ConnectionDao connectionDao = new ConnectionDao(); string returnString = IdProConstants.SUCCESS; SqlCommand cmd = null; SqlDataReader rs = null; long Customer_ID = 0; string query = "INSERT INTO Customer([First_name],[Last_name],[DOB],[SSN],[Address],[City],[State],[zip],[Primary_email],[Secondary_Email],[phone1],[phone2],[Customer_Type]) VALUES (@First_name,@Last_name,@DOB,@SSN,@Address,@City,@State,@zip,@Primary_email,@Secondary_Email,@phone1,@phone2,@Customer_Type);SELECT Customer_ID=scope_identity();"; try { strdrop = customer.dropphone1; cmd = connectionDao.getSqlCommand(query, conn, trans); SqlParameter param1 = new SqlParameter(); param1.ParameterName = "@First_name"; param1.Value = customer.firstname; cmd.Parameters.Add(param1); SqlParameter param2 = new SqlParameter(); param2.ParameterName = "@Last_name"; param2.Value = customer.lastname; cmd.Parameters.Add(param2); SqlParameter param3 = new SqlParameter(); param3.ParameterName = "@SSN"; param3.Value = customer.ssn; cmd.Parameters.Add(param3); SqlParameter param4 = new SqlParameter(); param4.ParameterName = "@Address"; param4.Value = customer.address1; cmd.Parameters.Add(param4); SqlParameter param5 = new SqlParameter(); param5.ParameterName = "@City"; param5.Value = customer.city; cmd.Parameters.Add(param5); SqlParameter param6 = new SqlParameter(); param6.ParameterName = "@State"; param6.Value = customer.states; cmd.Parameters.Add(param6); SqlParameter param7 = new SqlParameter(); param7.ParameterName = "@zip"; param7.Value = customer.zip; cmd.Parameters.Add(param7); SqlParameter param9 = new SqlParameter(); param9.ParameterName = "@Primary_email"; param9.Value = customer.primaryemail; cmd.Parameters.Add(param9); SqlParameter param10 = new SqlParameter(); param10.ParameterName = "@Secondary_Email"; param10.Value = customer.secondaryemail; cmd.Parameters.Add(param10); SqlParameter param11 = new SqlParameter(); param11.ParameterName = "@phone1"; param11.Value = customer.phone1; cmd.Parameters.Add(param11); SqlParameter param12 = new SqlParameter(); param12.ParameterName = "@phone2"; param12.Value = customer.phone2; cmd.Parameters.Add(param12); SqlParameter param16 = new SqlParameter(); param16.ParameterName = "@Customer_Type"; param16.Value = "primary"; cmd.Parameters.Add(param16); SqlParameter param17 = new SqlParameter(); param17.ParameterName = "@DOB"; param17.Value = customer.dob; cmd.Parameters.Add(param17); rs = cmd.ExecuteReader(); if (rs.Read()) { Customer_ID = Int32.Parse(rs["Customer_ID"].ToString()); } //while (rs.Read()) //{ // customerNumber = Int32.Parse(rs["Customer_ID"].ToString()); //} } catch (Exception exception) { System.Diagnostics.Trace.WriteLine("[CustomerDAO:addCustomerBasicInfo] Exception " + exception.StackTrace); } finally { connectionDao.closeDabaseEntities(cmd, rs); } return Customer_ID; }
public string customeradd(customer customer1, Account account) { string str = ""; SqlConnection conn = null; SqlTransaction trans = null; string returnString = IdProConstants.SUCCESS; CustomerDAO customerdao = new CustomerDAO(); AccountDao accountdao = new AccountDao(); ConnectionDao ConnectionDao = new ConnectionDao(); Customer_Account_O2M customerAccountO2M = new Customer_Account_O2M(); Customer_Account_O2MDAO customerAccountO2Mservice = new Customer_Account_O2MDAO(); try { conn = ConnectionDao.getConnection(); trans = conn.BeginTransaction(); customerAccountO2M.CustomerID = customerdao.addCustomerBasicInfo(conn, trans, customer1); if (!customerAccountO2M.CustomerID.Equals(0)) { customerAccountO2M.AccountID = accountdao.addAccountBasicInfo(conn, trans, account); if (!customerAccountO2M.AccountID.Equals(0)) { returnString = customerAccountO2Mservice.addCustomerAccountO2MInfo(conn, trans,customerAccountO2M); } str = customer1.cofirstname; if (str != "") { customerAccountO2M.CustomerID = customerdao.addCustomerCoinfo(conn, trans, customer1); if (!customerAccountO2M.CustomerID.Equals(0)) { customerAccountO2M.AccountID = accountdao.addAccountBasicInfo(conn, trans, account); if (!customerAccountO2M.AccountID.Equals(0)) { returnString = customerAccountO2Mservice.addCustomerAccountO2MInfo(conn, trans, customerAccountO2M); } } } } if (returnString.Equals(IdProConstants.SUCCESS)) { trans.Commit(); } else { trans.Rollback(); } } catch (Exception exception) { trans.Rollback(); System.Diagnostics.Trace.WriteLine("[EmployeeServices:addEmployee] Exception " + exception.StackTrace); } finally { ConnectionDao.closeConnection(conn); } string finalreturnvalue=""; if (returnString == "Success") { finalreturnvalue = "Thanks record saved successfully"; } else { finalreturnvalue = "Sorry, Your request could not be processed. Please try after some time"; } return finalreturnvalue; }