public string CalculatePercentMarks(DataTable dtResult, string subject, decimal MaxMarks, decimal percentValue)
{
// 10 %, 40% , 50 %
string result = "0.00";
// to remove divide by zero error
if (MaxMarks == 0)
{
MaxMarks = 1;
}
decimal totalMarks = 0;
string exm;
foreach (DataRow drResult2 in dtResult.Rows)
{
exm = util.CheckNull(drResult2["ExamName"]).ToUpper();
if ((percentValue == 10 && (exm == "Unit Test I".ToUpper() ||
exm == "Unit Test II".ToUpper() ||
exm == "Unit Test III".ToUpper())) ||
(percentValue == 40 && exm == "Half Yearly".ToUpper()) ||
(percentValue == 50 && exm == "Final Exam".ToUpper())
)
{
if (util.CheckNull(drResult2[subject]) != "-")
{
totalMarks += util.CheckNullDecimal(drResult2[subject]);
}
else
{
totalMarks += 0;
}
}
}
result = util.CheckNullDecimal((((totalMarks / MaxMarks) * percentValue))).ToString();
return(result);
}
public decimal GetExamMaxMarks(DBSite site, string examId)
{
string mmStr = util.CheckNull(GetExamList(site, Util_BLL.User.UserId, examId)[0].MaxMarks);
if (util.isDecimal(mmStr))
{
return(util.CheckNullDecimal(mmStr));
}
else
{
return(-1);
}
}
// ------------ Get Tax Info -------------------------------------
public List <TaxEntity> GetInfo(DBSite site, string tax_id = "")
{
List <TaxEntity> tax_list = new List <TaxEntity>();
TaxEntity tax = null;
string qry = " SELECT "
+ "TaxId"
+ ", TaxName"
+ ", TaxPercent"
+ ", TaxAmount"
+ " FROM tblTaxMaster"
+ " WHERE "
+ " UserId =" + Util_BLL.User.UserId
+ " AND FYear=" + Util_BLL.User.fYear;
if (tax_id != "")
{
qry += " AND TaxId=" + tax_id;
}
DataTable dt = site.ExecuteSelect(qry);
foreach (DataRow row in dt.Rows)
{
tax = new TaxEntity();
tax.TaxId = util.CheckNullInt(row["TaxId"]);
tax.TaxName = util.CheckNull(row["TaxName"]);
tax.TaxPercent = util.CheckNullDecimal(row["TaxPercent"]);
tax.TaxAmount = util.CheckNullDecimal(row["TaxAmount"]);
tax_list.Add(tax);
}
return(tax_list);
}
protected void SaveExamMarks()
{
ExamMarksBll emBll = new ExamMarksBll();
site = new DBSite();
List <ExamMarksBll.ExamMarksEntity> marksList = new List <ExamMarksBll.ExamMarksEntity>();
ExamMarksBll.ExamMarksEntity mark;
decimal MaxMarksByExam = 0;
ExamMasterBll exbLL = new ExamMasterBll();
SubjectMasterBLL sBll = new SubjectMasterBLL();
string subjectGrpType = "MARKS";
if (!isUpdate)
{
MaxMarksByExam = exbLL.GetExamMaxMarks(site, ddlExam.SelectedValue);
subjectGrpType = sBll.GetSubjectGroupType(site, ddlSubject.SelectedValue);
}
foreach (GridViewRow gr in gridView1.Rows)
{
mark = new ExamMarksBll.ExamMarksEntity();
CheckBox cb = (CheckBox)gr.Cells[0].FindControl("ckbPresent");
if (cb.Checked)
{
mark.IsPresent = 1;
}
else
{
mark.IsPresent = 0;
}
mark.StudentMasterId = util.CheckNullInt(gr.Cells[2].Text);
TextBox txt = (TextBox)gr.Cells[9].FindControl("txtMarksObtained");
mark.StudentName = util.CheckNull(gr.Cells[3].Text);
// if new then check for subject type -grade or marks
if (!isUpdate)
{
if (subjectGrpType.ToUpper() == "MARKS")
{
if (!util.isDecimal(txt.Text))
{
lblError.Text = " Marks Obtained By '" + mark.StudentName + "' is not valid decimal.";
lblError.Visible = true;
return;
}
}
else // grade
{
//if (util.isDecimal(txt.Text))
//{
// lblError.Text = " Marks Obtained By '" + mark.StudentName + "' is not valid Grade.";
// lblError.Visible = true;
// return;
//}
}
}
else // update
{
subjectGrpType = util.CheckNull(gr.Cells[11].Text);
if (subjectGrpType.ToUpper() == "MARKS")
{
if (!util.isDecimal(txt.Text))
{
lblError.Text = " Marks Obtained By '" + mark.StudentName + "' is not valid decimal.";
lblError.Visible = true;
return;
}
}
else
{
//if (util.isDecimal(txt.Text))
//{
// lblError.Text = " Marks Obtained By '" + mark.StudentName + "' is not valid Grade.";
// lblError.Visible = true;
// return;
//}
}
}
if (util.isDecimal(txt.Text))
{
if (isUpdate)
{
MaxMarksByExam = util.CheckNullDecimal(gr.Cells[10].Text);
}
decimal marksObtained = util.CheckNullDecimal(txt.Text);
if (marksObtained <= MaxMarksByExam)
{
mark.MarksObtained = util.CheckNull(marksObtained);
}
else
{
lblError.Text = " Marks Obtained By '" + mark.StudentName + "' Can Not Be More Than Max Marks ( " + MaxMarksByExam + " ) ";
lblError.Visible = true;
return;
}
}
else
{
mark.MarksObtained = util.CheckNull(txt.Text);
}
mark.classId = util.CheckNullInt(gridView1.DataKeys[gr.RowIndex].Values["classId"]);
mark.SectionId = util.CheckNullInt(gridView1.DataKeys[gr.RowIndex].Values["SectionId"]);
if (isUpdate)
{
mark.SubjectId = util.CheckNullInt(gridView1.DataKeys[gr.RowIndex].Values["SubjectId"]);
mark.ExamId = util.CheckNullInt(gridView1.DataKeys[gr.RowIndex].Values["ExamId"]);
}
else
{
mark.SubjectId = util.CheckNullInt(ddlSubject.SelectedValue);
mark.ExamId = util.CheckNullInt(ddlExam.SelectedValue);
}
mark.ExamMarksId = util.CheckNullInt(gridView1.DataKeys[gr.RowIndex].Values["ExamMarksId"]);
mark.SubUserID = Util_BLL.SubUser.SubuserId;
mark.UserID = Util_BLL.User.UserId;
mark.FYear = Util_BLL.User.fYear;
marksList.Add(mark);
}
emBll.SaveMarks(site, marksList, isUpdate, false);
string msg = " Successfully Added ! ";
if (isUpdate)
{
msg = " Successfully Updated ! ";
}
lblMessage.Text = msg;
lblMessage.Visible = true;
ClearErrorMessage();
}
public List <User> GetUsers(DBSite site, string user_id = "")
{
List <User> user_list = new List <User>();
User user = null;
string qry = " SELECT "
+ " UserInfoId"
+ ", UserName"
+ ", Email"
+ ", SenderId"
+ ", SMSUser"
+ ", SMSPassword"
+ ", SMSDelivery"
+ ", UserPassword"
+ ", CreationDate"
+ ", AmountPaid"
+ ", StartDate"
+ ", EndDate"
+ ", Address"
+ ", City"
+ ", Country"
+ ", Phone"
+ ", Mobile"
+ ", TinNumber"
+ ", SalesTaxNumber"
+ ", CSTNumber"
+ ", UserType"
+ ", IsUnicode"
+ ", NumberOfSubusers"
+ ", SMSUser"
+ ", SMSPassword"
+ ", SMSDelivery"
+ ", Remarks";
qry += " FROM tblUserInfo";
if (user_id != "")
{
qry += " WHERE UserInfoId=" + user_id;
}
DataTable dt = site.ExecuteSelect(qry);
foreach (DataRow row in dt.Rows)
{
user = new User();
user.UserId = util.CheckNullInt(row["UserInfoId"]);
user.UserName = util.CheckNull(row["UserName"]);
user.EmailId = util.CheckNull(row["Email"]);
user.SenderId = util.CheckNull(row["SenderId"]);
user.SMSUser = util.CheckNull(row["SMSUser"]);
user.SMSPassword = util.CheckNull(row["SMSPassword"]);
user.SMSDelivery = util.CheckNullInt(row["SMSDelivery"]);
user.UserPassword = util.CheckNull(row["UserPassword"]);
user.AmountPaid = util.CheckNullDecimal(row["AmountPaid"]);
user.CreationDate = ((DateTime)row["CreationDate"]).ToShortDateString();
user.StartDate = ((DateTime)row["StartDate"]).ToShortDateString();
user.EndDate = ((DateTime)row["EndDate"]).ToShortDateString();
user.Address = util.CheckNull(row["Address"]);
user.City = util.CheckNull(row["City"]);
user.Country = util.CheckNull(row["Country"]);
user.Phone = util.CheckNull(row["Phone"]);
user.Mobile = util.CheckNull(row["Mobile"]);
user.TinNumber = util.CheckNull(row["TinNumber"]);
user.SalesTaxNumber = util.CheckNull(row["SalesTaxNumber"]);
//user.SalesTaxNumber = System.Web.HttpContext.Current.Server.MapPath("\\image\\logo.bmp");
// user.SalesTaxNumber = "http://www.gsc99.com/images/logo/bpslogo.jpg";
user.CSTNumber = util.CheckNull(row["CSTNumber"]);
user.UserType = util.CheckNullInt(row["UserType"]);
user.IsUnicode = util.CheckNullInt(row["IsUnicode"]) == 1 ? true : false;
user.Remarks = util.CheckNull(row["Remarks"]);
user.NumberOFSubusers = util.CheckNullInt(row["NumberOfSubusers"]);
user.fYear = util.CheckNullInt(util.GetHomeSetting(site, "CurrentFYear"));
user.Subusers = GetSubusers(site, user.UserId + ""); //------ get subuser list --------
user.Permissions = GetPermissions(site, user.UserId + ""); //----- get permission list --------
user_list.Add(user);
}
return(user_list);
}
// ---------------- Authenticate User ----------------------------------------------
public UserBLL.User AuthenticateUser(DBSite site, string email_id, string password, string user_id = "", int subuserId = -1)
{
UserBLL.User user = null;
UserBLL user_bll = new UserBLL();
string qry = "SELECT "
+ " UserInfoId"
+ ", UserName"
+ ", Email"
+ ", SenderID"
+ ", SMSUser"
+ ", SMSPassword"
+ ", SMSDelivery"
+ ", UserPassword"
+ ", CreationDate"
+ ", AmountPaid"
+ ", StartDate"
+ ", EndDate"
+ ", Address"
+ ", City"
+ ", Country"
+ ", Phone"
+ ", Mobile"
+ ", TinNumber"
+ ", SalesTaxNumber"
+ ", CSTNumber"
+ ", IsActive"
+ ", UserType"
+ ", IsUnicode"
+ ", Remarks"
+ ", NumberOfSubusers"
+ " FROM tblUserInfo";
if (user_id == "")
{
qry += " WHERE Email='" + email_id + "'"
+ " AND UserPassword='******'";
}
else
{
qry += " WHERE UserInfoId=" + user_id;
}
DataTable dt = site.ExecuteSelect(qry);
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
user = new UserBLL.User();
user.UserId = util.CheckNullInt(row["UserInfoID"]);
user.UserName = util.CheckNull(row["UserName"]);
user.EmailId = util.CheckNull(row["Email"]);
user.SenderId = util.CheckNull(row["SenderID"]);
user.SMSUser = util.CheckNull(row["SMSUser"]);
user.SMSPassword = util.CheckNull(row["SMSPassword"]);
user.SMSDelivery = util.CheckNullInt(row["SMSDelivery"]);
user.UserPassword = util.CheckNull(row["UserPassword"]);
user.CreationDate = Convert.ToDateTime(row["CreationDate"]).ToShortDateString();
user.AmountPaid = util.CheckNullDecimal(row["AmountPaid"]);
user.StartDate = Convert.ToDateTime(row["StartDate"]).ToShortDateString();
user.EndDate = Convert.ToDateTime(row["EndDate"]).ToShortDateString();
user.Address = util.CheckNull(row["Address"]);
user.City = util.CheckNull(row["City"]);
user.Country = util.CheckNull(row["Country"]);
user.Phone = util.CheckNull(row["Phone"]);
user.Mobile = util.CheckNull(row["Mobile"]);
user.TinNumber = util.CheckNull(row["TinNumber"]);
user.SalesTaxNumber = util.CheckNull(row["SalesTaxNumber"]);
user.CSTNumber = util.CheckNull(row["CSTNumber"]);
user.IsActive = util.CheckNull(row["IsActive"]);
user.UserType = util.CheckNullInt(row["UserType"]);
user.IsUnicode = util.CheckNullInt(row["IsUnicode"]) == 1 ? true : false;
user.Remarks = util.CheckNull(row["Remarks"]);
user.NumberOFSubusers = util.CheckNullInt(row["NumberOfSubusers"]);
user.fYear = util.CheckNullInt(util.GetHomeSetting(site, "CurrentFYear"));
user.Subusers = user_bll.GetSubusers(site, user.UserId + ""); //------- Subusers --------
user.Current_subuserId = subuserId;
user.Permissions = user_bll.GetPermissions(site, user.UserId + ""); //--------- Permissions ------------------
}
return(user);
}
public List <ProductMasterEntity> GetProductMasterData(DBSite site, string id = "")
{
List <ProductMasterEntity> productMasterList = new List <ProductMasterEntity>();
string qry = "";
qry += " SELECT ";
qry += " ProductMasterId, ProductID, ProductName, OpeningBalance, ProductDate, CostPrice, SellingPrice ";
qry += " , ReOrderQty , ProductDescription, product.UserID, FYear, product.CreatedAt ";
qry += ", category.CategoryId CategoryId ";
qry += ", CategoryName ";
qry += ", uom.UOMId UOMId ";
qry += ", product.LocationId LocationId ";
qry += ", product.AccountId AccountId ";
qry += ", UnitName ";
qry += " FROM ( tblProductMaster as product ";
qry += " LEFT OUTER JOIN tblProductCategory as category ON ";
qry += " product.CategoryId = category.CategoryId )";
qry += " LEFT OUTER JOIN tblUOM as uom ON ";
qry += " product.UOM= uom.UOMId ";
qry += " WHERE product.UserID = " + Util_BLL.User.UserId;
if (id != string.Empty)
{
qry += " AND ProductMasterId = " + id;
}
DataTable dt = site.ExecuteSelect(qry);
ProductMasterEntity pme;
foreach (DataRow dr in dt.Rows)
{
pme = new ProductMasterEntity();
pme.ProductMasterId = util.CheckNullInt(dr["ProductMasterId"]);
pme.ProductId = util.CheckNull(dr["ProductID"]);
pme.ProductName = util.CheckNull(dr["ProductName"]);
pme.OpeningBalance = util.ToDecimal(util.CheckNullDecimal(dr["OpeningBalance"]));
DateTime date = Convert.ToDateTime(dr["ProductDate"]);
pme.productDate = date;
pme.CostPrice = util.ToDecimal(util.CheckNullDecimal(dr["CostPrice"]));
pme.SellingPrice = util.ToDecimal(util.CheckNullDecimal(dr["SellingPrice"]));
pme.UOM = util.CheckNullInt(dr["UOMId"]);
pme.UOMName = util.CheckNull(dr["UnitName"]);
pme.CategoryID = util.CheckNullInt(dr["CategoryID"]);
pme.CategoryName = util.CheckNull(dr["CategoryName"]);
pme.AccountId = util.CheckNullInt(dr["AccountId"]);
pme.LocationId = util.CheckNullInt(dr["LocationId"]);
pme.ReOrderQty = util.CheckNullDecimal(dr["ReOrderQty"]);
pme.ProductDescription = util.CheckNull(dr["ProductDescription"]);
pme.UserID = util.CheckNullInt(dr["UserID"]);
pme.FYear = util.CheckNullInt(dr["FYear"]);
productMasterList.Add(pme);
}
return(productMasterList);
}
public List <AccountMasterEntity> GetAccountMasterData(DBSite site, int userId, string id = "")
{
List <AccountMasterEntity> accountMasterList = new List <AccountMasterEntity>();
string qry = "";
qry += "SELECT ";
qry += "AccountMasterId, AccountName, CreationDate, OpeningBalance,";
qry += "DRCR, Address, City, Phone, Mobile, Email,";
qry += " Remarks, acc.UserID, FYear ";
qry += ", acc.GroupID GroupID";
qry += ", GroupName ";
qry += " FROM tblAccountMaster as acc ";
qry += " LEFT OUTER JOIN tblGroup as gp ON ";
qry += " acc.GroupId = gp.GroupId ";
//qry += Util_BLL.GetUserWhereCondition();
qry += " Where acc.UserId = " + Util_BLL.User.UserId;
if (id != string.Empty)
{
qry += "AND AccountMasterId = " + id;
}
DataTable dt = site.ExecuteSelect(qry);
AccountMasterEntity ac;
foreach (DataRow dr in dt.Rows)
{
ac = new AccountMasterEntity();
ac.AccountMasterId = util.CheckNullInt(dr["AccountMasterId"].ToString());
ac.AccountName = dr["AccountName"].ToString();
DateTime date = Convert.ToDateTime(dr["CreationDate"]);
ac.CreationDate = date.ToShortDateString();
ac.OpeningBalance = util.ToDecimal(util.CheckNullDecimal(dr["OpeningBalance"]));
ac.DRCR = util.CheckNullInt(dr["DRCR"]);
ac.DRCR_Name = (util.CheckNullInt(dr["DRCR"]) == 0) ? "Credit" : "Debit";
ac.Address = util.CheckNull(dr["Address"].ToString());
ac.City = util.CheckNull(dr["City"].ToString());
ac.Phone = util.CheckNull(dr["Phone"].ToString());
ac.Mobile = util.CheckNull(dr["Mobile"].ToString());
ac.Email = util.CheckNull(dr["Email"].ToString());
ac.Remarks = util.CheckNull(dr["Remarks"].ToString());
ac.GroupId = util.CheckNullInt(dr["GroupId"]);
ac.GroupName = util.CheckNull(dr["GroupName"]);
ac.UserID = util.CheckNullInt(dr["UserID"]);
ac.FYear = util.CheckNullInt(dr["FYear"]);
accountMasterList.Add(ac);
}
return(accountMasterList);
}
