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