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