public BaseResponse <Response> SaveOrUpdate(CustomerDto customer)
{
Response response = null;
try
{
using (SqlConnection con = new SqlConnection(constring))
{
using (SqlCommand cmd = new SqlCommand("Usp_SaveOrUpdateCustomer", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", customer.Id);
cmd.Parameters.AddWithValue("@CustomerName", customer.CustomerName);
cmd.Parameters.AddWithValue("@ContributionNumber", customer.ContributionNumber);
cmd.Parameters.AddWithValue("@Address", customer.Address);
cmd.Parameters.AddWithValue("@City", customer.City);
cmd.Parameters.AddWithValue("@PhoneNumber", customer.PhoneNumber);
cmd.Parameters.AddWithValue("@MobileNumber", customer.MobileNumber);
cmd.Parameters.AddWithValue("@OpeningBalance", customer.OpeningBalance);
cmd.Parameters.AddWithValue("@CreditLimit", customer.CreditLimit);
cmd.Parameters.AddWithValue("@StartCreditPeriod", customer.StartCreditPeriod);
cmd.Parameters.AddWithValue("@EndCreditPeriod", customer.EndCreditPeriod);
cmd.Parameters.AddWithValue("@DGEApproved", customer.DGEApproved);
cmd.Parameters.AddWithValue("@FaxNumber", customer.FaxNumber);
cmd.Parameters.AddWithValue("@Attendent", customer.Attendent);
cmd.Parameters.AddWithValue("@CompanyId", customer.CompanyId);
cmd.Parameters.AddWithValue("@IsActive", customer.IsActive);
SqlParameter parameter = new SqlParameter();
parameter = new SqlParameter("@message", SqlDbType.VarChar, 255);
parameter.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@customerId", DbType.Int64);
parameter.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parameter);
parameter = new SqlParameter("@statusCode", DbType.Int64);
parameter.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parameter);
con.Open();
cmd.ExecuteNonQuery();
response = new Response();
response.Message = cmd.Parameters["@message"].Value.ToString();
response.Id = Int32.Parse(cmd.Parameters["@customerId"].Value.ToString());
response.StatusCode = Int32.Parse(cmd.Parameters["@statusCode"].Value.ToString());
con.Close();
if (response != null)
{
return(ResponseFactory.SuccessForType <Response>(response, "Success."));
}
}
}
return(ResponseFactory.ErrorForType <Response>("Something went wrong."));
}
catch (Exception ex)
{
return(ResponseFactory.ErrorForType <Response>(ex.Message));
}
}
public BaseResponse <LoginViewModel> GetCompany(int userId, int companyId)
{
LoginViewModel viewModel = null;
if (userId > 0 && companyId > 0)
{
var getUser = TCSOfficeDbContext.Logins.FirstOrDefault(z => z.Id == userId);
if (getUser != null)
{
var getCompany = TCSOfficeDbContext.Companies.FirstOrDefault(z => z.Id == companyId);
if (getCompany != null)
{
viewModel = new LoginViewModel();
viewModel.CompanyName = getCompany.CompanyName;
viewModel.Address = getCompany.Address;
viewModel.Phone = getCompany.Phone;
viewModel.Email = getUser.Email;
viewModel.UserName = getUser.UserName;
return(ResponseFactory.SuccessForType <LoginViewModel>(viewModel, "Successfully fetched details."));
}
}
return(ResponseFactory.ErrorForType <LoginViewModel>("Something went wrong."));
}
return(ResponseFactory.ErrorForType <LoginViewModel>("Company is invalid."));
}
