public static ACC_HeadUser GetACC_UserByUserID(string UserID)
{
ACC_HeadUser aCC_HeadUser = new ACC_HeadUser();
SqlACC_HeadUserProvider sqlACC_HeadUserProvider = new SqlACC_HeadUserProvider();
aCC_HeadUser = sqlACC_HeadUserProvider.GetACC_HeadUserByUserID(UserID);
return aCC_HeadUser;
}
public static ACC_HeadUser GetACC_RowStatusByRowStatusID(int RowStatusID)
{
ACC_HeadUser aCC_HeadUser = new ACC_HeadUser();
SqlACC_HeadUserProvider sqlACC_HeadUserProvider = new SqlACC_HeadUserProvider();
aCC_HeadUser = sqlACC_HeadUserProvider.GetACC_HeadUserByRowStatusID(RowStatusID);
return aCC_HeadUser;
}
public static ACC_HeadUser GetACC_HeadUserByHeadUserID(int HeadUserID)
{
ACC_HeadUser aCC_HeadUser = new ACC_HeadUser();
SqlACC_HeadUserProvider sqlACC_HeadUserProvider = new SqlACC_HeadUserProvider();
aCC_HeadUser = sqlACC_HeadUserProvider.GetACC_HeadUserByHeadUserID(HeadUserID);
return aCC_HeadUser;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ACC_HeadUser aCC_HeadUser = new ACC_HeadUser ();
aCC_HeadUser.HeadUserID= int.Parse(Request.QueryString["ID"].ToString());
aCC_HeadUser.HeadUserName= txtHeadUserName.Text;
aCC_HeadUser.HeadID= int.Parse(ddlHeadID.SelectedValue);
aCC_HeadUser.UserID= ddlUserID.SelectedValue;
aCC_HeadUser.AddedBy= Profile.card_id;
aCC_HeadUser.AddedDate= DateTime.Now;
aCC_HeadUser.UpdatedBy= Profile.card_id;
aCC_HeadUser.UpdateDate= DateTime.Now;
aCC_HeadUser.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue);
bool resutl =ACC_HeadUserManager.UpdateACC_HeadUser(aCC_HeadUser);
Response.Redirect("AdminDisplayACC_HeadUser.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ACC_HeadUser aCC_HeadUser = new ACC_HeadUser ();
// aCC_HeadUser.HeadUserID= int.Parse(ddlHeadUserID.SelectedValue);
aCC_HeadUser.HeadUserName= txtHeadUserName.Text;
aCC_HeadUser.HeadID= int.Parse(ddlHeadID.SelectedValue);
aCC_HeadUser.UserID= ddlUserID.SelectedValue;
aCC_HeadUser.AddedBy= Profile.card_id;
aCC_HeadUser.AddedDate= DateTime.Now;
aCC_HeadUser.UpdatedBy= Profile.card_id;
aCC_HeadUser.UpdateDate= DateTime.Now;
aCC_HeadUser.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue);
int resutl =ACC_HeadUserManager.InsertACC_HeadUser(aCC_HeadUser);
Response.Redirect("AdminDisplayACC_HeadUser.aspx");
}
private void getHeadMoney(bool IsNewCompany)
{
string UserID = "";
string UserName = "";
if (ddlAccountingUserMoney.Visible != false)
{
UserID = ddlAccountingUserMoney.SelectedValue;
UserName = ddlAccountingUserMoney.SelectedItem.Text;
}
else
{
UserID = txtStudentCodeMoney.Text;
UserName = txtStudentCodeMoney.Text;
}
if (IsNewCompany)
{
ACC_AccountingUser aCC_AccountingUser = new ACC_AccountingUser();
// aCC_AccountingUser.AccountingUserID= int.Parse(ddlAccountingUserID.SelectedValue);
aCC_AccountingUser.AccountingUserName = txtNewCompanyMoney.Text;
UserName = txtNewCompanyMoney.Text;
aCC_AccountingUser.UserTypeID = int.Parse(ddlUserTypeIDMoney.SelectedValue);
aCC_AccountingUser.AddedBy = Profile.card_id;
aCC_AccountingUser.AddedDate = DateTime.Now;
aCC_AccountingUser.UpdatedBy = Profile.card_id;
aCC_AccountingUser.UpdateDate = DateTime.Now;
aCC_AccountingUser.RowStatusID = 1;
UserID = ACC_AccountingUserManager.InsertACC_AccountingUser(aCC_AccountingUser).ToString();
}
DataSet dsHeadUser = ACC_HeadUserManager.GetACC_UserByUserIDnUserTypeIDnAccountID(UserID, int.Parse(ddlUserTypeIDMoney.SelectedValue), int.Parse(ddlAccountForMoney.SelectedValue));
int HeadID = 0;
string headNameMoney = "";
if (dsHeadUser.Tables[0].Rows.Count == 0)
{
//need to create the dead for this user
ACC_Head aCC_Head = new ACC_Head();
// aCC_Head.HeadID= int.Parse(ddlHeadID.SelectedValue);
aCC_Head.HeadName = ddlAccountForMoney.SelectedItem.Text + " --> " + UserName;
headNameMoney = aCC_Head.HeadName;
aCC_Head.HeadCode = ""; //code need to generate automatically
aCC_Head.AccountID = int.Parse(ddlAccountID.SelectedValue);
aCC_Head.AddedBy = Profile.card_id;
aCC_Head.AddedDate = DateTime.Now;
aCC_Head.UpdatedBy = Profile.card_id;
aCC_Head.UpdateDate = DateTime.Now;
aCC_Head.RowStatusID = 1;
HeadID = ACC_HeadManager.InsertACC_Head(aCC_Head);
//add in the head user
ACC_HeadUser aCC_HeadUser = new ACC_HeadUser();
// aCC_HeadUser.HeadUserID= int.Parse(ddlHeadUserID.SelectedValue);
aCC_HeadUser.HeadUserName = "";
aCC_HeadUser.HeadID = HeadID;
aCC_HeadUser.UserID = UserID;
aCC_HeadUser.UserTypeID = int.Parse(ddlUserTypeIDMoney.SelectedValue);
aCC_HeadUser.AddedBy = Profile.card_id;
aCC_HeadUser.AddedDate = DateTime.Now;
aCC_HeadUser.UpdatedBy = Profile.card_id;
aCC_HeadUser.UpdateDate = DateTime.Now;
aCC_HeadUser.RowStatusID = 1;
ACC_HeadUserManager.InsertACC_HeadUser(aCC_HeadUser);
}
else
{
HeadID = int.Parse(dsHeadUser.Tables[0].Rows[0]["HeadID"].ToString());
headNameMoney = dsHeadUser.Tables[0].Rows[0]["HeadName"].ToString();
}
hfHeadIDMoney.Value = HeadID.ToString();
lblHeadNameMoney.Text = headNameMoney;
}
private void getHead(bool IsNewCompany)
{
string UserID = "";
string UserName = "";
if (ddlAccountingUser.Visible != false)
{
UserID = ddlAccountingUser.SelectedValue;
if (ddlUserTypeID.SelectedValue == "2" || ddlUserTypeID.SelectedValue == "3")
{
UserName = ddlAccountingUser.SelectedItem.Text;
}
else
{
UserName = "******" + ddlAccountingUser.SelectedValue + ") " + ddlAccountingUser.SelectedItem.Text;
}
}
else
{
STD_Student student=STD_StudentManager.GetHR_StudnetByStudentCode(txtStudentCode.Text);
UserID = student.StudentID;
UserName = "******" + txtStudentCode.Text + ") " + student.StudentName;
}
if (IsNewCompany && txtNewCompany.Text!="")
{
ACC_AccountingUser aCC_AccountingUser = new ACC_AccountingUser();
// aCC_AccountingUser.AccountingUserID= int.Parse(ddlAccountingUserID.SelectedValue);
aCC_AccountingUser.AccountingUserName = txtNewCompany.Text;
UserName = txtNewCompany.Text;
aCC_AccountingUser.UserTypeID = int.Parse(ddlUserTypeID.SelectedValue);
aCC_AccountingUser.AddedBy = Profile.card_id;
aCC_AccountingUser.AddedDate = DateTime.Now;
aCC_AccountingUser.UpdatedBy = Profile.card_id;
aCC_AccountingUser.UpdateDate = DateTime.Now;
aCC_AccountingUser.RowStatusID = 1;
UserID = ACC_AccountingUserManager.InsertACC_AccountingUser(aCC_AccountingUser).ToString();
}
int HeadID = 0;
string headName = "";
if (ddlAccountID.SelectedValue != "0")
{
DataSet dsHeadUser = ACC_HeadUserManager.GetACC_UserByUserIDnUserTypeIDnAccountID(UserID, int.Parse(ddlUserTypeID.SelectedValue), int.Parse(ddlAccountID.SelectedValue));
if (dsHeadUser.Tables[0].Rows.Count == 0)
{
//need to create the dead for this user
ACC_Head aCC_Head = new ACC_Head();
// aCC_Head.HeadID= int.Parse(ddlHeadID.SelectedValue);
aCC_Head.HeadName = ddlAccountID.SelectedItem.Text+" " + UserName;
headName = aCC_Head.HeadName;
aCC_Head.HeadCode = ""; //code need to generate automatically
aCC_Head.AccountID = int.Parse(ddlAccountID.SelectedValue);
aCC_Head.AddedBy = Profile.card_id;
aCC_Head.AddedDate = DateTime.Now;
aCC_Head.UpdatedBy = Profile.card_id;
aCC_Head.UpdateDate = DateTime.Now;
aCC_Head.RowStatusID = 1;
HeadID = ACC_HeadManager.InsertACC_Head(aCC_Head);
//add in the head user
ACC_HeadUser aCC_HeadUser = new ACC_HeadUser();
// aCC_HeadUser.HeadUserID= int.Parse(ddlHeadUserID.SelectedValue);
aCC_HeadUser.HeadUserName = "";
aCC_HeadUser.HeadID = HeadID;
aCC_HeadUser.UserID = UserID;
aCC_HeadUser.UserTypeID = int.Parse(ddlUserTypeID.SelectedValue);
aCC_HeadUser.AddedBy = Profile.card_id;
aCC_HeadUser.AddedDate = DateTime.Now;
aCC_HeadUser.UpdatedBy = Profile.card_id;
aCC_HeadUser.UpdateDate = DateTime.Now;
aCC_HeadUser.RowStatusID = 1;
ACC_HeadUserManager.InsertACC_HeadUser(aCC_HeadUser);
}
else
{
HeadID = int.Parse(dsHeadUser.Tables[0].Rows[0]["HeadID"].ToString());
headName = dsHeadUser.Tables[0].Rows[0]["HeadName"].ToString();
}
}
else
{
return;
}
hfHeadID.Value = HeadID.ToString();
lblHeadName.Text = headName;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["Remarks"] != null)
{
txtRemarks.Text = Request.QueryString["Remarks"];
}
txtCUCCheckDate.Text = DateTime.Today.ToShortDateString();
BasicAccountIDLoad();
Session["doubleEntry"] = null;
if (Request.QueryString["BasicAccountID"] != null)
{
ddlBasicAccountID.SelectedValue = Request.QueryString["BasicAccountID"];
ddlBasicAccountID.Visible = false;
//lblBasicAccountID.Visible = false;
ddlBasicAccountID_SelectedIndexChanged(this, new EventArgs());
}
if (Request.QueryString["SubBasicAccountID"] != null)
{
ddlSubBasicAccountID.SelectedValue = Request.QueryString["SubBasicAccountID"];
ddlSubBasicAccountID.Visible = false;
//lblSubBasicAccountID.Visible = false;
ddlSubBasicAccountID_SelectedIndexChanged(this, new EventArgs());
}
UserTypeIDLoad();
AccountIDLoad();
if (Request.QueryString["HeadID"] != null)
{
ddlBasicAccountID.SelectedValue = Request.QueryString["HeadID"];
ddlBasicAccountID.Visible = false;
//lblBasicAccountID.Visible = false;
ddlBasicAccountID_SelectedIndexChanged(this, new EventArgs());
}
if (Request.QueryString["AccountID"] != null)
{
ddlBasicAccountID.Visible = false;
ddlAccountID.SelectedValue = Request.QueryString["AccountID"];
}
if (Request.QueryString["AccountIDMoney"] != null)
{
ddlAccountForMoney.SelectedValue = Request.QueryString["AccountIDMoney"];
}
if (Request.QueryString["UserTypeID"] != null)
{
ddlUserTypeID.SelectedValue = Request.QueryString["UserTypeID"];
ddlUserTypeID_SelectedIndexChanged(this, new EventArgs());
if (Request.QueryString["EmployeeID"] != null)
{
ddlAccountingUser.SelectedValue = Request.QueryString["EmployeeID"];
txtAmount.Text = Request.QueryString["Amount"];
txtAmount.Enabled = false;
txtAmountMoney.Text = Request.QueryString["Amount"];
ddlSubBasicAccountID.Visible = false;
ddlBasicAccountID.Visible = false;
txtStudentCode.Visible = false;
getHead(false);
}
}
if (Request.QueryString["UserTypeIDMoney"] != null)
{
if (ddlUserTypeIDMoney.Items.Count > 0)
{
if (ddlUserTypeIDMoney.SelectedItem.Text == "Student")
{
txtStudentCodeMoney.Visible = true;
ddlAccountingUserMoney.Visible = false;
//txtStudentCodeMoney.ReadOnly = true;
}
else
{
ddlAccountingUserMoney.Visible = true;
txtStudentCodeMoney.Visible = false;
ddlUserTypeIDMoney.SelectedValue = Request.QueryString["UserTypeIDMoney"];
ddlUserTypeIDMoney_SelectedIndexChanged(this, new EventArgs());
if (Request.QueryString["UserTypeIDMoney"] == "2")
{
ddlAccountingUserMoney.Enabled = false;
ddlUserTypeIDMoney.Enabled = false;
}
}
}
}
//HeadIDLoad();
RowStatusIDLoad();
loadDebitOrCredit();
if (Request.QueryString["ID"] != null)
{
int ID = Int32.Parse(Request.QueryString["ID"]);
btnAdd.Visible = false;
btnUpdate.Visible = true;
showACC_VoucherData();
}
initialDataLoad();
if (Request.QueryString["StudentCode"] != null)
{
txtStudentCode.Visible = true;
txtStudentCode.Enabled = false;
ddlAccountingUser.Visible = false;
txtAmount.Text = Request.QueryString["Amount"];
txtAmount.Enabled = false;
txtAmountMoney.Text = txtAmount.Text;
txtStudentCode.Text = Request.QueryString["StudentCode"];
getHead(false);
//btnVarify_OnClick(this, new EventArgs());
//btnAdd_Click(this, new EventArgs());
}
//processing for check bounching
if (Request.QueryString["CheckGiverHeadID"] != null)
{
ACC_HeadUser headuser = new ACC_HeadUser();
headuser = ACC_HeadUserManager.GetACC_HeadByHeadID(int.Parse(Request.QueryString["CheckGiverHeadID"]));
ddlUserTypeID.SelectedValue = headuser.UserTypeID.ToString();
if (headuser.UserTypeID == 1)
{
txtStudentCode.Text = STD_StudentManager.GetSTD_StudentByStudentID(headuser.UserID).StudentCode;
btnVarify_OnClick(this, new EventArgs());
ddlUserTypeID_SelectedIndexChanged(this, new EventArgs());
}
else
{
ddlUserTypeID_SelectedIndexChanged(this, new EventArgs());
ddlAccountingUser.SelectedValue = headuser.UserID.ToString();
ddlAccountingUser_SelectedIndexChanged(this, new EventArgs());
}
txtAmount.Text = Request.QueryString["Amount"];
txtAmount.Enabled = false;
//btnAdd_Click(this, new EventArgs());
//btnAdd.Visible = false;
}
}
}
public bool UpdateACC_HeadUser(ACC_HeadUser aCC_HeadUser)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateACC_HeadUser", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@HeadUserID", SqlDbType.Int).Value = aCC_HeadUser.HeadUserID;
cmd.Parameters.Add("@HeadUserName", SqlDbType.NVarChar).Value = aCC_HeadUser.HeadUserName;
cmd.Parameters.Add("@HeadID", SqlDbType.Int).Value = aCC_HeadUser.HeadID;
cmd.Parameters.Add("@UserID", SqlDbType.NVarChar).Value = aCC_HeadUser.UserID;
cmd.Parameters.Add("@UserTypeID", SqlDbType.Int).Value = aCC_HeadUser.UserTypeID;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = aCC_HeadUser.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = aCC_HeadUser.UpdateDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = aCC_HeadUser.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public ACC_HeadUser GetACC_HeadUserFromReader(IDataReader reader)
{
try
{
ACC_HeadUser aCC_HeadUser = new ACC_HeadUser
(
DataAccessObject.IsNULL<int>(reader["HeadUserID"]),
DataAccessObject.IsNULL<string>(reader["HeadUserName"]),
DataAccessObject.IsNULL<int>(reader["HeadID"]),
DataAccessObject.IsNULL<string>(reader["UserID"]),
DataAccessObject.IsNULL<int>(reader["UserTypeID"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"])
);
return aCC_HeadUser;
}
catch(Exception ex)
{
return null;
}
}
private void showACC_HeadUserData()
{
ACC_HeadUser aCC_HeadUser = new ACC_HeadUser ();
aCC_HeadUser = ACC_HeadUserManager.GetACC_HeadUserByHeadUserID(Int32.Parse(Request.QueryString["ID"]));
txtHeadUserName.Text =aCC_HeadUser.HeadUserName.ToString();
ddlHeadID.SelectedValue =aCC_HeadUser.HeadID.ToString();
ddlUserID.SelectedValue =aCC_HeadUser.UserID.ToString();
ddlRowStatusID.SelectedValue =aCC_HeadUser.RowStatusID.ToString();
}
public static ACC_HeadUser GetACC_UserTypeByUserTypeID(int UserTypeID)
{
ACC_HeadUser aCC_HeadUser = new ACC_HeadUser();
SqlACC_HeadUserProvider sqlACC_HeadUserProvider = new SqlACC_HeadUserProvider();
aCC_HeadUser = sqlACC_HeadUserProvider.GetACC_HeadUserByUserTypeID(UserTypeID);
return aCC_HeadUser;
}
public static bool UpdateACC_HeadUser(ACC_HeadUser aCC_HeadUser)
{
SqlACC_HeadUserProvider sqlACC_HeadUserProvider = new SqlACC_HeadUserProvider();
return sqlACC_HeadUserProvider.UpdateACC_HeadUser(aCC_HeadUser);
}
public static int InsertACC_HeadUser(ACC_HeadUser aCC_HeadUser)
{
SqlACC_HeadUserProvider sqlACC_HeadUserProvider = new SqlACC_HeadUserProvider();
return sqlACC_HeadUserProvider.InsertACC_HeadUser(aCC_HeadUser);
}
