public Task <string> Update(PharCompanyModel aModel) { try { string msg = ""; const string query = @"UPDATE tbl_PHAR_COMPANY SET Name=@Name,Address=@Address,Phone=@Phone,OpeningBalance=@OpeningBalance,Status=@Status,EntryDate=@EntryDate,UserName=@UserName WHERE Id=@Id" ; Con.Open(); var cmd = new SqlCommand(query, Con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Id", aModel.CompanyId); cmd.Parameters.AddWithValue("@Name", aModel.ComName); cmd.Parameters.AddWithValue("@Address", aModel.Address); cmd.Parameters.AddWithValue("@Phone", aModel.Phone); cmd.Parameters.AddWithValue("@OpeningBalance", aModel.OpeningBal); cmd.Parameters.AddWithValue("@Status", aModel.ComStatus); cmd.Parameters.AddWithValue("@EntryDate", aModel.ComEntryDate.ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@UserName", aModel.UserName); cmd.ExecuteNonQuery(); Con.Close(); return(Task.FromResult("Update successful")); } catch (Exception exception) { if (Con.State == ConnectionState.Open) { Con.Close(); } return(Task.FromResult(exception.Message)); } }
public Task <string> Update(PharCompanyModel aModel) { try { const string query = @"UPDATE tbl_PHAR_COMPANY SET Name=@Name,Address=@Address,Phone=@Phone,EntryDate=@EntryDate,UserName=@UserName WHERE Id=@Id"; Con.Open(); var cmd = new SqlCommand(query, Con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Id", aModel.Id); cmd.Parameters.AddWithValue("@Name", aModel.Name); // cmd.Parameters.AddWithValue("@Name", aModel.); cmd.Parameters.AddWithValue("@Address", aModel.Address); cmd.Parameters.AddWithValue("@Phone", aModel.Phone); cmd.Parameters.AddWithValue("@EntryDate", aModel.EntryDate); cmd.Parameters.AddWithValue("@UserName", aModel.UserName); cmd.ExecuteNonQuery(); Con.Close(); return(Task.FromResult("Update Successful")); } catch (Exception exception) { if (Con.State == ConnectionState.Open) { Con.Close(); } return(Task.FromResult(exception.Message)); } }
public Task <string> Save(PharCompanyModel aModel) { try { string partyId = GetPartyId(); const string query = @"INSERT INTO tbl_PHAR_COMPANY (Code,Name,Address,Phone,OpeningBalance,Status,EntryDate,UserName) VALUES (@Code,@Name,@Address,@Phone,@OpeningBalance,@Status,@EntryDate,@UserName)" ; Con.Open(); var cmd = new SqlCommand(query, Con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Code", partyId); // cmd.Parameters.AddWithValue("@Id", aModel.CompanyId); cmd.Parameters.AddWithValue("@Name", aModel.ComName); cmd.Parameters.AddWithValue("@Address", aModel.Address); cmd.Parameters.AddWithValue("@Phone", aModel.Phone); cmd.Parameters.AddWithValue("@OpeningBalance", aModel.OpeningBal); cmd.Parameters.AddWithValue("@Status", aModel.ComStatus); cmd.Parameters.AddWithValue("@EntryDate", aModel.ComEntryDate.ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@UserName", aModel.UserName); 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 async Task <HttpResponseMessage> Save_PartyInfo([FromBody] PharCompanyModel aModel) { var formate = RequestFormat.JsonFormaterString(); try { if (string.IsNullOrEmpty(aModel.ComName)) { return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "error", Msg = "Name is Null" })); } else { if (_gt.FncSeekRecordNew("tbl_PHAR_COMPANY", "Id=" + aModel.CompanyId + "") == false) { if (_gt.FncSeekRecordNew("tbl_PHAR_COMPANY", "Name='" + aModel.ComName + "'") == true) { return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "error", Msg = "Name Already Exist" }, formate)); } else { string msg = await _gt.Save(aModel); return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "success", Msg = msg }, formate)); } } else { string msg = await _gt.Update(aModel); return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "success", Msg = msg }, formate)); } } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "error", Msg = ex.ToString() }, formate)); } }