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