public void UpdateRMAFORFaultyGoods(CreditNoteRMAFaultyGoods obj)
{
var creditId = Convert.ToInt32(obj.CreditNoteId);
if (GetRMAByCreditNoteIdAndSuppName(creditId, obj.SupplierName) == 0)
{
new CreditNotesDAL(CONNSTRING).WriteSupplierIntoRMA(obj.CreditNoteId, obj.SupplierName);
}
SqlConnection conn = new SqlConnection();
conn.ConnectionString = CONNSTRING;
string sqlStmt = @"UPDATE dbo.RMATracking SET BatchNumber=@batchNumber,
ModelNumber=@modelNumber,ErrorMessage=@errorMessage,FaultyNotes=@faultyNotes WHERE CreditNoteID =@crId AND SupplierName=@suppName";
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
conn.Open();
cmd.CommandText = sqlStmt;
cmd.Parameters.Add("@batchNumber", SqlDbType.NVarChar).Value = obj.BatchNumber;
cmd.Parameters.Add("@modelNumber", SqlDbType.NVarChar).Value = obj.ModelNumber;
cmd.Parameters.Add("@errorMessage", SqlDbType.NVarChar).Value = obj.ErrorMessage;
cmd.Parameters.Add("@suppName", SqlDbType.NVarChar).Value = obj.SupplierName;
cmd.Parameters.Add("@faultyNotes", SqlDbType.NVarChar).Value = obj.FaultyNotes;
cmd.Parameters.Add("@crId", SqlDbType.Int).Value = creditId;
cmd.ExecuteNonQuery();
}
conn.Close();
}
public CreditNoteRMAFaultyGoods GetRMAFaultyGoods(CreditNoteRMAFaultyGoods obj)
{
var creditId = Convert.ToInt32(obj.CreditNoteId);
SqlConnection conn = new SqlConnection();
conn.ConnectionString = CONNSTRING;
var strSqlContactStmt = @"SELECT RMAID,BatchNumber,ModelNumber,ErrorMessage,FaultyNotes from RMATracking
rt where rt.CreditNoteID=@creditNoteId AND rt.SupplierName=@suppName";
using (SqlCommand cmd = new SqlCommand())
{
cmd.Parameters.AddWithValue("@creditNoteId", SqlDbType.Int).Value = creditId;
cmd.Parameters.AddWithValue("@suppName", SqlDbType.NVarChar).Value = obj.SupplierName;
cmd.CommandText = strSqlContactStmt;
cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
obj.RMAId = Convert.ToInt32(reader["RMAID"].ToString());
if (reader["BatchNumber"] != DBNull.Value)
{
obj.BatchNumber = reader["BatchNumber"].ToString();
}
if (reader["ModelNumber"] != DBNull.Value)
{
obj.ModelNumber = reader["ModelNumber"].ToString();
}
if (reader["ErrorMessage"] != DBNull.Value)
{
obj.ErrorMessage = reader["ErrorMessage"].ToString();
}
if (reader["FaultyNotes"] != DBNull.Value)
{
obj.FaultyNotes = reader["FaultyNotes"].ToString();
}
}
}
}
conn.Close();
return(obj);
}
