public Task <string> Save(PartyInfoModel aModel)
{
try
{
string partyId = GetPartyId();
const string query = @"INSERT INTO PartyInfo (PartyId,PartyName,Address,ContactNo,OpeningBal,TrDate,UserName,EntryTime,ShowPC,PStatus,VendorFor,Ratio)
VALUES (@PartyId,@PartyName,@Address,@ContactNo,@OpeningBal,@TrDate,@UserName,@EntryTime,@ShowPC,@PStatus,@VendorFor,@Ratio)" ;
Con.Open();
var cmd = new SqlCommand(query, Con);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@PartyId", partyId);
cmd.Parameters.AddWithValue("@PartyName", aModel.PartyName);
cmd.Parameters.AddWithValue("@Address", aModel.Address);
cmd.Parameters.AddWithValue("@ContactNo", aModel.ContactNo);
cmd.Parameters.AddWithValue("@OpeningBal", aModel.OpeningBal);
cmd.Parameters.AddWithValue("@TrDate", aModel.TrDate);
cmd.Parameters.AddWithValue("@UserName", aModel.UserName);
cmd.Parameters.AddWithValue("@EntryTime", aModel.EntryTime);
cmd.Parameters.AddWithValue("@ShowPC", aModel.ShowPC);
cmd.Parameters.AddWithValue("@PStatus", aModel.PStatus);
cmd.Parameters.AddWithValue("@VendorFor", aModel.VendorFor);
cmd.Parameters.AddWithValue("@Ratio", aModel.Ratio);
cmd.ExecuteNonQuery();
Con.Close();
return(Task.FromResult("Save successful"));
}
catch (Exception exception)
{
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
return(Task.FromResult(exception.Message));
}
}
public Task <string> Update(PartyInfoModel aModel)
{
try
{
string msg = "";
const string query = @"UPDATE PartyInfo
SET IdNo=@IdNo,PartyName=@PartyName,Address=@Address,ContactNo=@ContactNo,OpeningBal=@OpeningBal,TrDate=@TrDate,PStatus=@PStatus,Ratio=@Ratio
WHERE IdNo=@IdNo" ;
Con.Open();
var cmd = new SqlCommand(query, Con);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@IdNo", aModel.IdNo);
// cmd.Parameters.AddWithValue("@PartyId", aModel.PartyId);
cmd.Parameters.AddWithValue("@PartyName", aModel.PartyName);
cmd.Parameters.AddWithValue("@Address", aModel.Address);
cmd.Parameters.AddWithValue("@ContactNo", aModel.ContactNo);
cmd.Parameters.AddWithValue("@OpeningBal", aModel.OpeningBal);
cmd.Parameters.AddWithValue("@TrDate", aModel.TrDate.ToString("yyyy-MM-dd"));
// cmd.Parameters.AddWithValue("@UserName", aModel.UserName);
// cmd.Parameters.AddWithValue("@EntryTime", aModel.EntryTime);
// cmd.Parameters.AddWithValue("@ShowPC", aModel.ShowPC);
cmd.Parameters.AddWithValue("@PStatus", aModel.PStatus);
// cmd.Parameters.AddWithValue("@VendorFor", aModel.VendorFor);
cmd.Parameters.AddWithValue("@Ratio", aModel.Ratio);
cmd.ExecuteNonQuery();
Con.Close();
return(Task.FromResult("Update successful"));
}
catch (Exception exception)
{
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
return(Task.FromResult(exception.Message));
}
}
