public void AddModifyRawMaterialDistributionItem(ItemQty itm)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("RawMaterialDistributionItemsLog", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ItemId", itm.ItemId);
cmd.Parameters.AddWithValue("@RawMaterialDisID", itm.RawMaterialDisId);
cmd.Parameters.AddWithValue("@rawMaterialId", itm.RawMaterialId);
cmd.Parameters.AddWithValue("@Qty", itm.Qty);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
// return rv;
}
public ReturnValues ShopKeeperAcceptApproveSendToShop(AdminApprove adap)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("ShopKeeperAcceptsFinishProductToShop", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", adap.UserId);
cmd.Parameters.AddWithValue("@BusinessId", adap.BusinessId);
cmd.Parameters.AddWithValue("@ItemApprovalId", adap.ItemApprovalId);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 100);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
Console.WriteLine("We are catching an exception");
CommonUtilityClass.ExceptionLog(ex);
Console.WriteLine(ex.Message);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
public int CheckLoginCredentials(UserData ld)
{
int n = 0;
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("CheckCredentialsLogin", conn))
{
// @businessid = 1,@userid = 1,@lastpassword = '',@returnvalue = 1
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userid", ld.UserID);
cmd.Parameters.AddWithValue("@businessid", ld.businessid);
cmd.Parameters.AddWithValue("@lastpassword", ld.lastUpdatePassword);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
n = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
}
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(n);
}
public ReturnValues AddRemoveSellProductQty(AddRemoveQty pr)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("AddRemoveProductQty", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@productId", pr.productId);
cmd.Parameters.AddWithValue("@userid", pr.userId);
cmd.Parameters.AddWithValue("@businessid", pr.businessId);
cmd.Parameters.AddWithValue("@addRemove", pr.ActionType);
cmd.Parameters.AddWithValue("@Qty", pr.Qty);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
return(rv);
}
}
public string GenerateUserToken(int userid, int businessid)
{
string tokenString = ce.GenerateRandomeStrings(20);
string returnToken = "";
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("GenerateToken", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@token", tokenString);
cmd.Parameters.AddWithValue("@userId", userid);
cmd.Parameters.AddWithValue("@businessId", businessid);
cmd.Parameters.Add("@returnvalue", System.Data.SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
if (Convert.ToInt32(cmd.Parameters["@returnvalue"].Value) == 1)
{
returnToken = tokenString;// ce.Encrypt(tokenString, CommonUtilityClass.apiEncryptKey);
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(returnToken);
}
public ReturnValues RegisterBusiness(BizRegModel bzm)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("RegisterBusinessAccount", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessname", bzm.businessName);
cmd.Parameters.AddWithValue("@businessAddress", bzm.businessAddress);
cmd.Parameters.AddWithValue("@fullname", bzm.fullname);
cmd.Parameters.AddWithValue("@email", bzm.email);
cmd.Parameters.AddWithValue("@phone", bzm.phone);
cmd.Parameters.AddWithValue("@password", bzm.password);
cmd.Parameters.Add("@returnvalue", System.Data.SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
public ReturnValues ChangePassword(ChangePassword cp)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("ChangePassword", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessid", cp.businessid);
cmd.Parameters.AddWithValue("@userid", cp.UserID);
cmd.Parameters.AddWithValue("@oldpass", cp.OldPassword);
cmd.Parameters.AddWithValue("@newpass", cp.NewPassword);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
public ReturnValues CreateEditStore(ShopModel sm)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("CreateNewStore", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StoreId", sm.StoreId);
cmd.Parameters.AddWithValue("@userId", sm.UserId);
cmd.Parameters.AddWithValue("@businessId", sm.BusinessId);
cmd.Parameters.AddWithValue("@StoreName", sm.StoreName);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 100);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
return(rv);
}
}
public void AddModifyRawMaterialForFinishedProductsItems(ProductRawMaterial itm)
{
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("AddFinishedProductRawMaterials", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessid", itm.businessId);
cmd.Parameters.AddWithValue("@productID", itm.productId);
cmd.Parameters.AddWithValue("@rawMaterialID", itm.rawMaterialID);
cmd.Parameters.AddWithValue("@rawMaterialQty", itm.rawMaterialQty);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
/* rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
* rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value); */
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
/* rv.StatusCode = 2000;
* rv.StatusMessage = "An Error Occured"; */
}
}
}
}
public List <PushedProductToStore> GetAllFinishedProductSentToShop(int businessid, int userid, int type)
{
List <PushedProductToStore> prl = new List <PushedProductToStore>();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("getAllProductPushedToShop", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessid", businessid);
cmd.Parameters.AddWithValue("@userid", userid);
cmd.Parameters.AddWithValue("@type", type);
try
{
PushedProductToStore _prl;
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
_prl = new PushedProductToStore
{
ProductId = Convert.ToInt32(reader["ProductId"]),
ProductName = reader["ProductName"] is DBNull ? null : (String)reader["ProductName"],
Qty = Convert.ToDecimal(reader["Qty"]),
StoreId = Convert.ToInt32(reader["StoreId"]),
StoreName = reader["StoreName"] is DBNull ? null : (String)reader["StoreName"],
ActionType = reader["ActionType"] is DBNull ? null : (String)reader["ActionType"],
ProductionManagerId = Convert.ToInt32(reader["ProductionManagerId"]),
ProductionMangerName = reader["ProductionMangerName"] is DBNull ? null : (String)reader["ProductionMangerName"],
AdminId = Convert.ToInt32(reader["AdminId"]),
AdminWhoApproved = reader["AdminWhoApproved"] is DBNull ? null : (String)reader["AdminWhoApproved"],
StoreManagerId = Convert.ToInt32(reader["StoreManagerId"]),
StoreManagerAssignTo = reader["StoreManagerAssignTo"] is DBNull ? null : (String)reader["StoreManagerAssignTo"],
StoreManagerAcceptDate = string.IsNullOrEmpty(reader["StoreManagerAcceptDate"].ToString()) ? (DateTime?)null : DateTime.Parse(reader["StoreManagerAcceptDate"].ToString()),
StoreManagerAccept = Convert.ToInt32(reader["StoreManagerAccept"]),
YesAsAdmin = Convert.ToInt32(reader["YesAsAdmin"]),
};
prl.Add(_prl);
}
}
else
{
prl = null;
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(prl);
}
public List <RawDisbursement> getRawMaterialDistributionTicket(int businessid)
{
List <RawDisbursement> rd = new List <RawDisbursement>();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("getRawMaterialDistributionTicket", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessid", businessid);
try
{
RawDisbursement _sm = new RawDisbursement();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
_sm = new RawDisbursement
{
DistributId = Convert.ToInt32(reader["DistributId"]),
BusinessId = Convert.ToInt32(reader["BusinessId"]),
UserId = Convert.ToInt32(reader["UserId"]),
CreatedBy = reader["createdUser"] is DBNull ? null : (String)reader["createdUser"],
createddate = Convert.ToDateTime(reader["createddate"]),
ProductManagerId = Convert.ToInt32(reader["ProductManagerId"]),
productManagerName = reader["productmanager"] is DBNull ? null : (String)reader["productmanager"],
productmanagerAccept = Convert.ToInt32(reader["productManagerAccept"]),
productManagerAcceptDate = reader["productManagerAcceptDate"] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(reader["productManagerAcceptDate"]),
AdminApprove = Convert.ToInt32(reader["AdminApprove"]),
AdminName = reader["AdminApproveName"] is DBNull ? null : (String)reader["AdminApproveName"],
AdminApproveDate = reader["AdminApproveDate"] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(reader["AdminApproveDate"]),
Items = getRawMaterialDistributionTicketItems(Convert.ToInt32(reader["DistributId"])),
};
rd.Add(_sm);
}
}
else
{
rd = null;
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(rd);
}
public static SqlConnection getConnection()
{
try
{
con = new SqlConnection(connectionstring());
con.Open();
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
return(con);
}
public List <StoreModel> GetAllMaterials(int businessid)
{
List <StoreModel> sm = new List <StoreModel>();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("getBusinessRawMaterials", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessid", businessid);
try
{
StoreModel _sm = new StoreModel();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
_sm = new StoreModel {
id = Convert.ToInt32(reader["id"]),
BusinessId = Convert.ToInt32(reader["businessID"]),
userid = Convert.ToInt32(reader["createdBy"]),
createdByName = reader["createdByName"] is DBNull ? null : (String)reader["createdByName"],
MaterialName = reader["MaterialName"] is DBNull ? null : (String)reader["MaterialName"],
Qty = Convert.ToDecimal(reader["Qty"]),
CostPrice = Convert.ToDecimal(reader["CostPrice"]),
SellingPrice = Convert.ToDecimal(reader["SellingPrice"]),
MeasureId = Convert.ToInt32(reader["measureID"]),
measurementTitle = reader["measurement"] is DBNull ? null : (String)reader["measurement"],
active = Convert.ToInt32(reader["active"]),
QtyAlert = Convert.ToDecimal(reader["QtyAlert"])
};
sm.Add(_sm);
}
}
else
{
sm = null;
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(sm);
}
public List <UserData> AllBusinessStaffList(int businessid)
{
List <UserData> AllStaff = new List <UserData>();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("SelectBusinessStaff", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessid", businessid);
try
{
UserData ud = new UserData();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ud = new UserData
{
businessid = Convert.ToInt32(reader["businessID"]),
UserID = Convert.ToInt32(reader["id"]),
email = reader["email"] is DBNull ? null : (String)reader["email"],
phone = reader["phoneNumber"] is DBNull ? null : (String)reader["phoneNumber"],
departmentID = Convert.ToInt32(reader["DepartmentID"]),
levelID = Convert.ToInt32(reader["levelID"]),
fullname = reader["fullname"] is DBNull ? null : (String)reader["fullname"],
active = Convert.ToInt32(reader["active"]),
lastUpdatePassword = Convert.ToDateTime(reader["lastUpdatePassword"]),
loggedIn = Convert.ToInt32(reader["loggedIn"]),
};
AllStaff.Add(ud);
}
}
else
{
ud = null;
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(AllStaff);
}
public List <productsList> GetProductsLists(int BusinessId)
{
List <productsList> prl = new List <productsList>();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("GetAllProducts", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessId", BusinessId);
try
{
productsList _prl = new productsList();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
_prl = new productsList
{
ProductId = Convert.ToInt32(reader["id"]),
ProductName = reader["ProductName"] is DBNull ? null : (String)reader["ProductName"],
Code = reader["Code"] is DBNull ? null : (String)reader["Code"],
SellingPercentage = Convert.ToDecimal(reader["SellingPercentage"]),
Qty = Convert.ToDecimal(reader["Qty"]),
CostOfRawMaterial = Convert.ToDecimal(reader["CostOfRawMaterial"]),
LastSellingPrice = Convert.ToDecimal(reader["LastSellingPrice"]),
ProductRawMaterials = GetProductsRawMaterial(Convert.ToInt32(reader["id"]), BusinessId)
};
prl.Add(_prl);
}
}
else
{
prl = null;
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(prl);
}
public UserData Login(LoginData ld)
{
UserData ud = new UserData();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("LoginUsers", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email", ld.email);
cmd.Parameters.AddWithValue("@password", ld.password);
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ud = new UserData {
businessid = Convert.ToInt32(reader["businessID"]),
UserID = Convert.ToInt32(reader["id"]),
email = reader["email"] is DBNull ? null : (String)reader["email"],
phone = reader["phoneNumber"] is DBNull ? null : (String)reader["phoneNumber"],
departmentID = Convert.ToInt32(reader["DepartmentID"]),
levelID = Convert.ToInt32(reader["levelID"]),
fullname = reader["fullname"] is DBNull ? null : (String)reader["fullname"],
active = Convert.ToInt32(reader["active"]),
lastUpdatePassword = Convert.ToDateTime(reader["lastUpdatePassword"]),
loggedIn = Convert.ToInt32(reader["loggedIn"]),
token = GenerateUserToken(Convert.ToInt32(reader["id"]), Convert.ToInt32(reader["businessID"]))
};
}
}
else
{
ud = null;
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(ud);
}
public List <ItemQty> getRawMaterialDistributionTicketItems(int TicketID)
{
List <ItemQty> sm = new List <ItemQty>();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("getRawMaterialDistributionTicketItems", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ticketID", TicketID);
try
{
ItemQty _sm = new ItemQty();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
_sm = new ItemQty
{
ItemId = Convert.ToInt32(reader["ItemId"]),
RawMaterialDisId = Convert.ToInt32(reader["RawMaterialDisID"]),
RawMaterialId = Convert.ToInt32(reader["RawMaterialId"]),
MaterialName = reader["MaterialName"] is DBNull ? null : (String)reader["MaterialName"],
measurement = reader["measurement"] is DBNull ? null : (String)reader["measurement"],
Qty = Convert.ToInt32(reader["Qty"])
};
sm.Add(_sm);
}
}
else
{
sm = null;
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(sm);
}
public static ReturnValuesBool ValidateToken(string token, int userid, int businessid)
{
ReturnValuesBool rvb = new ReturnValuesBool();
rvb.StatusFlag = false;
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("ValidateToken", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@token", token);
cmd.Parameters.AddWithValue("@businessId", businessid);
cmd.Parameters.AddWithValue("@userId", userid);
cmd.Parameters.Add("@returnvalue", System.Data.SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rvb.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
if (rvb.StatusCode == 1)
{
rvb.StatusFlag = true;
}
else
{
if (rvb.StatusCode == 2)
{
rvb.StatusMessage = "Token has expired";
}
if (rvb.StatusCode == 0)
{
rvb.StatusMessage = "Another user loggedIn with your account";
}
rvb.StatusFlag = false;
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(rvb);
}
public ReturnValues CreateEditFinishRawMaterial(ProductModel pm)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("CreateFinishedProducts", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mainProductId", pm.ProductId);
cmd.Parameters.AddWithValue("@ProductName", pm.ProductName);
cmd.Parameters.AddWithValue("@BusinessId", pm.BusinessId);
cmd.Parameters.AddWithValue("@userId", pm.UserId);
cmd.Parameters.AddWithValue("@categoryID", pm.CategoryId);
cmd.Parameters.AddWithValue("@SellingPrice", pm.SellingPrice);
cmd.Parameters.AddWithValue("@Code", pm.Code);
cmd.Parameters.AddWithValue("@active", 1);
cmd.Parameters.AddWithValue("@SellingPercentage", pm.SellingPercentage);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@productID", SqlDbType.Int);
cmd.Parameters["@productID"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
int myProductId = Convert.ToInt32(cmd.Parameters["@productID"].Value);
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
this.AddModifyRawMaterialForFinishedProducts(myProductId, pm.BusinessId, pm.productRaws);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
Console.WriteLine(ex.Message);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
public List <ShopModel> GetStoreLists(int BusinessId)
{
List <ShopModel> prl = new List <ShopModel>();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("GetAllStores", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessId", BusinessId);
try
{
ShopModel _prl = new ShopModel();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
_prl = new ShopModel
{
StoreId = Convert.ToInt32(reader["StoreId"]),
BusinessId = Convert.ToInt32(reader["BusinessId"]),
UserId = Convert.ToInt32(reader["adminId"]),
StoreName = reader["StoreName"] is DBNull ? null : (String)reader["StoreName"],
CreatedBy = reader["fullname"] is DBNull ? null : (String)reader["fullname"],
Createddate = string.IsNullOrEmpty(reader["Createddate"].ToString()) ? (DateTime?)null : DateTime.Parse(reader["Createddate"].ToString()),
};
prl.Add(_prl);
}
}
else
{
prl = null;
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(prl);
}
public List <ProductRawMaterial> GetProductsRawMaterial(int proid, int busId)
{
List <ProductRawMaterial> prl = new List <ProductRawMaterial>();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("getRawMaterialByProductId", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@productId", proid);
try
{
ProductRawMaterial _prl = new ProductRawMaterial();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
_prl = new ProductRawMaterial
{
productId = proid,
businessId = busId,
rawMaterialID = Convert.ToInt32(reader["rawMaterialID"]),
rawMaterialName = reader["MaterialName"] is DBNull ? null : (String)reader["MaterialName"],
rawMaterialQty = Convert.ToDecimal(reader["rawMaterialQty"]),
};
prl.Add(_prl);
}
}
else
{
prl = null;
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(prl);
}
public ReturnValues SendFinishProductToShop(FinishedProductToShop fp)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("SendFinishedProductToStore", conn))//call Stored Procedure
{
//fp.ActionType --- 1 -> Add to Store, 2-> Moved from store, 3-> sold from store
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BusinessId", fp.BusinessId);
cmd.Parameters.AddWithValue("@StoreId", fp.StoreId);
cmd.Parameters.AddWithValue("@ProductId", fp.ProductId);
cmd.Parameters.AddWithValue("@ActionQty", fp.ActionQty);
cmd.Parameters.AddWithValue("@ActionType", "Add To Store");
cmd.Parameters.AddWithValue("@ProductionManagerId", fp.ProductionManagerId);
cmd.Parameters.AddWithValue("@StoreManagerId", fp.StoreManagerId);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
Console.WriteLine("We are catching an exception");
CommonUtilityClass.ExceptionLog(ex);
Console.WriteLine(ex.Message);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
public ReturnValues CreateModifyRawMaterial(StoreModel str)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("RegisterModifyRawMaterial", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", str.id);
cmd.Parameters.AddWithValue("@userid", str.userid);
cmd.Parameters.AddWithValue("@businessid", str.BusinessId);
cmd.Parameters.AddWithValue("@materialName", str.MaterialName);
cmd.Parameters.AddWithValue("@costPrice", str.CostPrice);
cmd.Parameters.AddWithValue("@sellingPrice", str.SellingPrice);
cmd.Parameters.AddWithValue("@measureID", str.MeasureId);
cmd.Parameters.AddWithValue("@active", str.active);
cmd.Parameters.AddWithValue("@qtyAlert", str.QtyAlert);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
public ReturnValues RegisterBusinessStaff(UserData usd)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("RegisterBusinessStaff", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessid", usd.businessid);
cmd.Parameters.AddWithValue("@userid", usd.UserID);
cmd.Parameters.AddWithValue("@fullname", usd.fullname);
cmd.Parameters.AddWithValue("@email", usd.email);
cmd.Parameters.AddWithValue("@phone", usd.phone);
cmd.Parameters.AddWithValue("@departmentID", usd.departmentID);
cmd.Parameters.AddWithValue("@levelId", usd.levelID);
cmd.Parameters.AddWithValue("@password", usd.password);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
public ReturnValues AddRemove(StoreMaterial sm)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("AddRemoveSellRawMaterial", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@rawMaterialID", sm.RawMaterialId);
cmd.Parameters.AddWithValue("@userid", sm.UserId);
cmd.Parameters.AddWithValue("@businessid", sm.BusinessId);
cmd.Parameters.AddWithValue("@addRemove", sm.AddRemove);
cmd.Parameters.AddWithValue("@Qty", sm.Qty);
cmd.Parameters.AddWithValue("@costPrice", sm.costPrice);
cmd.Parameters.AddWithValue("@sellingPrice", sm.sellingPrice);
cmd.Parameters.AddWithValue("@updatePrice", sm.updatePrice);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
public ReturnValues AddModifyRawMaterialDistribution(RawDisbursement rd)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("CreateModifyRawMaterialDistribution", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DistributId", rd.DistributId);
cmd.Parameters.AddWithValue("@userid", rd.UserId);
cmd.Parameters.AddWithValue("@businessid", rd.BusinessId);
cmd.Parameters.AddWithValue("@ProductManagerId", rd.ProductManagerId);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
this.AddModifyRawMaterialDistribution(rv.StatusCode, rd.Items);
rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value);
rv.StatusCode = 1;
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
