///////////////////////////UPDATE
public string Update(PharStockInMainModel aModel)
{
try
{
string msg = "";
const string query = @"UPDATE PharStockInMain
SET InvoiceNo=@InvoiceNo,InvoiceDate=@InvoiceDate,CompanyID=@CompanyID,Remarks=@Remarks,UserName=@UserName,EntryTime=@EntryTime,Valid=@Valid,PNo=@PNo,SlipNo=@SlipNo,RefNo=@RefNo,RefDate=@RefDate,SlipDate=@SlipDate,Status=@Status
WHERE Remarks=@Remarks"; // no id
Con.Open();
var cmd = new SqlCommand(query, Con);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@InvoiceNo", aModel.InvoiceNo);
cmd.Parameters.AddWithValue("@InvoiceDate", aModel.InvoiceDate);
cmd.Parameters.AddWithValue("@CompanyID", aModel.CompanyID);
cmd.Parameters.AddWithValue("@Remarks", aModel.Remarks);
cmd.Parameters.AddWithValue("@UserName", aModel.UserName);
cmd.Parameters.AddWithValue("@EntryTime", aModel.EntryTime);
cmd.Parameters.AddWithValue("@Valid", aModel.Valid);
cmd.Parameters.AddWithValue("@PNo", aModel.PNo);
cmd.Parameters.AddWithValue("@SlipNo", aModel.SlipNo);
cmd.Parameters.AddWithValue("@RefNo", aModel.RefNo);
cmd.Parameters.AddWithValue("@RefDate", aModel.RefDate);
cmd.Parameters.AddWithValue("@SlipDate", aModel.SlipDate);
cmd.Parameters.AddWithValue("@Status", aModel.Status);
int rtn = cmd.ExecuteNonQuery();
return(msg = rtn == 1 ? "Update Success" : "Update Failed");
Con.Close();
return(msg);
}
catch (Exception exception)
{
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
return(exception.ToString());
}
}
///////////////////////////SAVE
public string Save(PharStockInMainModel aModel)
{
try
{
string msg = "";
const string query = @"INSERT INTO PharStockInMain (InvoiceNo,InvoiceDate,CompanyID,Remarks,UserName,EntryTime,Valid,PNo,SlipNo,RefNo,RefDate,SlipDate,Status)
VALUES (@InvoiceNo,@InvoiceDate,@CompanyID,@Remarks,@UserName,@EntryTime,@Valid,@PNo,@SlipNo,@RefNo,@RefDate,@SlipDate,@Status)";
Con.Open();
var cmd = new SqlCommand(query, Con);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@InvoiceNo", aModel.InvoiceNo);
cmd.Parameters.AddWithValue("@InvoiceDate", aModel.InvoiceDate);
cmd.Parameters.AddWithValue("@CompanyID", aModel.CompanyID);
cmd.Parameters.AddWithValue("@Remarks", aModel.Remarks);
cmd.Parameters.AddWithValue("@UserName", aModel.UserName);
cmd.Parameters.AddWithValue("@EntryTime", aModel.EntryTime);
cmd.Parameters.AddWithValue("@Valid", aModel.Valid);
cmd.Parameters.AddWithValue("@PNo", aModel.PNo);
cmd.Parameters.AddWithValue("@SlipNo", aModel.SlipNo);
cmd.Parameters.AddWithValue("@RefNo", aModel.RefNo);
cmd.Parameters.AddWithValue("@RefDate", aModel.RefDate);
cmd.Parameters.AddWithValue("@SlipDate", aModel.SlipDate);
cmd.Parameters.AddWithValue("@Status", aModel.Status);
int rtn = cmd.ExecuteNonQuery();
msg = rtn == 1 ? "Saved Success" : "Saved Failed";
Con.Close();
return(msg);
}
catch (Exception exception)
{
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
return(exception.ToString());
}
}
