private static void UpdateRMANUmber(DeltoneCRM_DAL.CreditNoteRMAHandler.RMAUpdate obj) { var CONNSTRING = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; SqlConnection conn = new SqlConnection(); conn.ConnectionString = CONNSTRING; if (new CreditNoteRMAHandler(CONNSTRING).GetRMAByCreditNoteIdAndSuppName(Convert.ToInt32(obj.CreId), obj.SuppName) == 0) { new CreditNotesDAL(CONNSTRING).WriteSupplierIntoRMA(obj.CreId, obj.SuppName); } var rmaId = new CreditNoteRMAHandler(CONNSTRING).GetRMAByCreditNoteIdAndSuppName(Convert.ToInt32(obj.CreId), obj.SuppName); var RMAID = rmaId.ToString(); String SqlStmt = @"UPDATE dbo.RMATracking SET SentToSupplier=@SentToSupplier, SentToSupplierDateTime=@SentToSupplierDateTime, ApprovedRMA=@ApprovedRMA, ApprovedRMADateTime=@ApprovedRMADateTime, CreditInXero=@CreditInXero, CreditInXeroDateTime=@CreditInXeroDateTime, RMAToCustomer=@RMAToCustomer, RMAToCustomerDateTime=@RMAToCustomerDateTime, AdjustedNoteFromSupplier=@AdjustedNoteFromSupplier, AdjustedNoteFromSupplierDateTime=@AdjustedNoteFromSupplierDateTime, Status=@Status, SupplierRMANumber=@SupplierRMANumber, TrackingNumber=@TrackingNumber , InHouse=@inHouse WHERE CreditNoteID =@crId AND SupplierName=@suppName"; SqlCommand cmd = new SqlCommand(SqlStmt, conn); cmd.Parameters.Add("@suppName", SqlDbType.NVarChar).Value = obj.SuppName; cmd.Parameters.Add("@crId", SqlDbType.Int).Value = obj.CreId; String STS = obj.STS; String STSWrite = String.Empty; //DateTime STSDateTime = new DateTime(); if (STS == "True") { STSWrite = "1"; } else { STSWrite = "0"; } String inHouse = obj.INHouse; String inHouseWrite = String.Empty; //DateTime STSDateTime = new DateTime(); if (inHouse == "True") { inHouseWrite = "1"; } else { inHouseWrite = "0"; } cmd.Parameters.AddWithValue("@inHouse", inHouseWrite); String ARMA = obj.ARMA; String ARMAWrite = String.Empty; if (ARMA == "True") { ARMAWrite = "1"; } else { ARMAWrite = "0"; } String CIX = obj.CIX; String CIXWrite = String.Empty; if (CIX == "True") { CIXWrite = "1"; } else { CIXWrite = "0"; } String RTC = obj.RTC; String RTCWrite = String.Empty; if (RTC == "True") { RTCWrite = "1"; } else { RTCWrite = "0"; } String ANFS = obj.ANFS; String ANFSWrite = String.Empty; if (ANFS == "True") { ANFSWrite = "1"; } else { ANFSWrite = "0"; } String NewStatus = String.Empty; //if (STS == "True" && ARMA == "True" && CIX == "True" && RTC == "True" && ANFS == "True") //{ // NewStatus = "COMPLETED"; //} //else //{ //} NewStatus = new CreditNotesDAL(CONNSTRING).RMAStatusByCreditIdAndSuppllier(obj.CreId, obj.SuppName); if (inHouse == "True") { NewStatus = "COMPLETED"; } else if (CIX == "True") { NewStatus = "COMPLETED"; } cmd.Parameters.AddWithValue("@SentToSupplier", STSWrite); if (STS == "True") { if (checkIfSTSHasValue(RMAID) == "") { cmd.Parameters.AddWithValue("@SentToSupplierDateTime", DateTime.Today); } else { cmd.Parameters.AddWithValue("@SentToSupplierDateTime", DateTime.Parse(checkIfSTSHasValue(RMAID))); } } else { cmd.Parameters.AddWithValue("@SentToSupplierDateTime", DBNull.Value); } cmd.Parameters.AddWithValue("@ApprovedRMA", ARMAWrite); if (ARMA == "True") { if (checkIfARMAHasValue(RMAID) == "") { cmd.Parameters.AddWithValue("@ApprovedRMADateTime", DateTime.Today); // sentRMATOCustomer(RMAID); // sent email to customer once RMA Approved } else { cmd.Parameters.AddWithValue("@ApprovedRMADateTime", DateTime.Parse(checkIfARMAHasValue(RMAID))); } } else { cmd.Parameters.AddWithValue("@ApprovedRMADateTime", DBNull.Value); } cmd.Parameters.AddWithValue("@CreditInXero", CIXWrite); if (CIX == "True") { if (checkIfCIXHasValue(RMAID) == "") { cmd.Parameters.AddWithValue("@CreditInXeroDateTime", DateTime.Today); } else { cmd.Parameters.AddWithValue("@CreditInXeroDateTime", DateTime.Parse(checkIfCIXHasValue(RMAID))); } } else { cmd.Parameters.AddWithValue("@CreditInXeroDateTime", DBNull.Value); } cmd.Parameters.AddWithValue("@RMAToCustomer", RTCWrite); if (RTC == "True") { if (checkIfRTCHasValue(RMAID) == "") { cmd.Parameters.AddWithValue("@RMAToCustomerDateTime", DateTime.Today); } else { cmd.Parameters.AddWithValue("@RMAToCustomerDateTime", DateTime.Parse(checkIfRTCHasValue(RMAID))); } } else { cmd.Parameters.AddWithValue("@RMAToCustomerDateTime", DBNull.Value); } cmd.Parameters.AddWithValue("@AdjustedNoteFromSupplier", ANFSWrite); if (ANFS == "True") { if (checkIfANFSHasValue(RMAID) == "") { cmd.Parameters.AddWithValue("@AdjustedNoteFromSupplierDateTime", DateTime.Today); } else { cmd.Parameters.AddWithValue("@AdjustedNoteFromSupplierDateTime", DateTime.Parse(checkIfANFSHasValue(RMAID))); } } else { cmd.Parameters.AddWithValue("@AdjustedNoteFromSupplierDateTime", DBNull.Value); } cmd.Parameters.AddWithValue("@Status", NewStatus); cmd.Parameters.AddWithValue("@SupplierRMANumber", obj.SRMAN); cmd.Parameters.AddWithValue("@TrackingNumber", obj.TN); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static void RMAUpdateMe(DeltoneCRM_DAL.CreditNoteRMAHandler.RMAUpdate obj) { UpdateRMANUmber(obj); }