public TaxMaster Put(TaxMaster item)
{
try
{
var identity = User.Identity as ClaimsIdentity;
int compid = 0, userid = 0;
foreach (Claim claim in identity.Claims)
{
if (claim.Type == "compid")
{
compid = int.Parse(claim.Value);
}
if (claim.Type == "userid")
{
userid = int.Parse(claim.Value);
}
}
logger.Info("User ID : {0} , Company Id : {1}", compid, userid);
return(context.PutTaxMaster(item));
}
catch
{
return(null);
}
}
public void DeleteTaxMaster()
{
try
{
var tax_master = new TaxMaster
{
CGST = 0,
SGST = 0,
IGST = 0,
IsActive = 0,
OperationType = 3
};
int DeleteStatus = _instanceRepository.InsertUpdateDeleteTaxMaster(tax_master);
if (DeleteStatus >= 1)
{
messageShow.singlemsgtext("Deleted Successfully");
}
else
{
messageShow.singlemsgtext("Unable to Delete");
}
GetTaxLedgerList();
}
catch (Exception _exception)
{
CmC.InsertException(_exception);
messageShow.singlemsgtext(CmC.ExceptionErrorMessage);
}
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
try
{
int DeleteId = 0;
if (ViewState["EditID"] != null)
{
DeleteId = Convert.ToInt32(ViewState["EditID"]);
}
if (DeleteId != 0)
{
Entity_TaxMaster.TaxId = DeleteId;
Entity_TaxMaster.UserId = Convert.ToInt32(Session["UserID"]);
Entity_TaxMaster.LoginDate = DateTime.Now;
int iDelete = Obj_TaxMaster.DeleteRecord(ref Entity_TaxMaster, out StrError);
if (iDelete != 0)
{
obj_Comman.ShowPopUpMsg("Record Deleted Successfully..!", this.Page);
MakeEmptyForm();
}
}
Entity_TaxMaster = null;
Obj_TaxMaster = null;
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
public DataTable SelectTaxByTaxID(TaxMaster _user)
{
SqlParameter[] param =
{
new SqlParameter("@taxid", _user.TaxId)
};
return(_da.GetFromDataTable("Select_TaxByTaxID", param));
}
public DataTable SelectTax(TaxMaster _user)
{
SqlParameter[] param =
{
new SqlParameter("@companyid", _user.CompanyId)
};
return(_da.GetFromDataTable("Select_Tax", param));
}
/// <summary>
/// Insert/update/delete the new tax details..
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public int InsertUpdateDeleteTaxMaster(TaxMaster tax_master)
{
int LastId = 0;
var DbManager = new DBManager("DBConnection");
DbManager.Insert(_StoredProcedures.InsertUpdateDeleteTaxMaster_SP, CommandType.StoredProcedure, _AdminMasterIRepository.AddParametersTax(tax_master), out LastId);
return(LastId);
}
public int Update(TaxModel model)
{
Mapper.CreateMap <TaxModel, TaxMaster>();
TaxMaster objUser = Dbcontext.TaxMasters.SingleOrDefault(m => m.TID == model.TID);
objUser = Mapper.Map(model, objUser);
return(Dbcontext.SaveChanges());
}
public ActionResult Tax(TaxMaster taxation)
{
var UserDetail = generic.GetUserDetail(User.Identity.GetUserId());
taxation.CorporateId = UserDetail.SubscriberId;
admin.AddTaxMaster(taxation.TaxationId, taxation.TaxName, taxation.TaxationValue, taxation.CorporateId);
return(RedirectToAction("Tax", "Invoice"));
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
int UpdateRow = 0, InserRow = 0;
try
{
if (ViewState["EditID"] != null)
{
Entity_TaxMaster.TaxId = Convert.ToInt32(ViewState["EditID"]);
}
Entity_TaxMaster.TaxName = TxtTaxName.Text.Trim();
//Entity_TaxMaster.TaxPer = Convert.ToDecimal(TxtTaxPer.Text.Trim());
//Entity_TaxMaster.EffectiveFrom = Convert.ToDateTime(TXTEFFECTIVEDATE.Text.Trim());
Entity_TaxMaster.UserId = Convert.ToInt32(Session["UserId"]);
Entity_TaxMaster.LoginDate = DateTime.Now;
//Entity_TaxMaster.TaxTypeID = Convert.ToInt32(RdoTaxType.SelectedValue.ToString());
UpdateRow = Obj_TaxMaster.UpdateRecord(ref Entity_TaxMaster, out StrError);
for (int i = 0; i < GridDetails.Rows.Count; i++)
{
Entity_TaxMaster.TaxId = Convert.ToInt32(ViewState["EditID"]);
if ((GridDetails.Rows[i].Cells[2]).Text != " ")
{
Entity_TaxMaster.ApplicableDate = DateTime.Parse((GridDetails.Rows[i].Cells[2]).Text);
}
else
{
Entity_TaxMaster.ApplicableDate = DateTime.Parse(DateTime.Now.ToString("dd/MMM/yyyy"));
}
Entity_TaxMaster.GST = Convert.ToDecimal(GridDetails.Rows[i].Cells[1].Text.ToString());
if (Convert.ToInt32(GridDetails.Rows[i].Cells[19].Text) == 0)
{
InserRow = Obj_TaxMaster.InsertTaxtls(ref Entity_TaxMaster, out StrError);
}
else
{
Entity_TaxMaster.TaxDtlsId = Convert.ToInt32(GridDetails.Rows[i].Cells[19].Text);
InserRow = Obj_TaxMaster.UpdateTaskDetails(ref Entity_TaxMaster, out StrError);
}
}
if (UpdateRow != 0)
{
obj_Comman.ShowPopUpMsg("Record Updated Successfully", this.Page);
MakeEmptyForm();
Entity_TaxMaster = null;
Obj_TaxMaster = null;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// Add parameters while adding the product details
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public IDbDataParameter[] AddParametersTax(TaxMaster tax_master)
{
parameters.Clear();
parameters.Add(dbManager.CreateParameter("@CGST", 50, tax_master.CGST, DbType.Decimal));
parameters.Add(dbManager.CreateParameter("@SGST", 50, tax_master.SGST, DbType.Decimal));
parameters.Add(dbManager.CreateParameter("@IGST", 50, tax_master.IGST, DbType.Decimal));
parameters.Add(dbManager.CreateParameter("@IsActive", 2, tax_master.IsActive, DbType.Int16));
parameters.Add(dbManager.CreateParameter("@OperationType", 2, tax_master.OperationType, DbType.Int16));
return(parameters.ToArray());
}
public int Add_TaxMaster(TaxMaster _user)
{
SqlParameter[] param = { new SqlParameter("@taxname", _user.TaxName),
new SqlParameter("@taxdesc", _user.TaxDesc),
new SqlParameter("@taxrate", _user.TaxRate),
new SqlParameter("@taxstatus", _user.TaxStatus),
new SqlParameter("@companyid", _user.CompanyId),
new SqlParameter("@createddate", _user.CreatedDate),
new SqlParameter("@modifieddate", _user.ModifiedDate) };
return(_da.Execute("Insert_TaxMaster", param));
}
public int UpdateRecord(ref TaxMaster Entity_Call, out string strError)
{
int iInsert = 0;
strError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(TaxMaster._Action, SqlDbType.BigInt);
SqlParameter pTaxId = new SqlParameter(TaxMaster._TaxId, SqlDbType.BigInt);
SqlParameter pTaxName = new SqlParameter(TaxMaster._TaxName, SqlDbType.NVarChar);
//SqlParameter pTaxPer = new SqlParameter(TaxMaster._TaxPer, SqlDbType.Decimal);
//SqlParameter pEffectiveFrom = new SqlParameter(TaxMaster._EffectiveFrom, SqlDbType.DateTime);
//SqlParameter pTaxTypeID = new SqlParameter(TaxMaster._TaxTypeID, SqlDbType.BigInt);
SqlParameter pUpdatedBy = new SqlParameter(TaxMaster._UserId, SqlDbType.BigInt);
SqlParameter pUpdatedDate = new SqlParameter(TaxMaster._LoginDate, SqlDbType.DateTime);
pAction.Value = 2;
pTaxId.Value = Entity_Call.TaxId;
pTaxName.Value = Entity_Call.TaxName;
//pTaxPer.Value = Entity_Call.TaxPer;
//pEffectiveFrom.Value = Entity_Call.EffectiveFrom;
//pTaxTypeID.Value = Entity_Call.TaxTypeID;
pUpdatedBy.Value = Entity_Call.UserId;
pUpdatedDate.Value = Entity_Call.LoginDate;
SqlParameter[] Param = new SqlParameter[] { pAction, pTaxId, pTaxName, pUpdatedBy, pUpdatedDate };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, TaxMaster.SP_ItemCategory, Param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
strError = ex.Message;
}
finally
{
Close();
}
return(iInsert);
}
public int InsertTax(TaxModel model)
{
try
{
Mapper.CreateMap <TaxModel, TaxMaster>();
TaxMaster objUser = Mapper.Map <TaxMaster>(model);
Dbcontext.TaxMasters.Add(objUser);
return(Dbcontext.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public TaxModel getByID(int id)
{
try
{
Mapper.CreateMap <TaxMaster, TaxModel>();
TaxMaster objCityMaster = Dbcontext.TaxMasters.Where(m => m.TID == id).SingleOrDefault();
TaxModel objCityItem = Mapper.Map <TaxModel>(objCityMaster);
return(objCityItem);
}
catch (Exception ex)
{
throw ex;
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
int InsertRow = 0, InserRowDtls = 0;
try
{
Ds = Obj_TaxMaster.ChkDuplicate(TxtTaxName.Text.Trim(), out StrError);
if (Ds.Tables[0].Rows.Count > 0)
{
obj_Comman.ShowPopUpMsg("Please Enter Another Tax Name..", this.Page);
TxtTaxName.Focus();
}
else
{
Entity_TaxMaster.TaxName = TxtTaxName.Text.Trim();
//Entity_TaxMaster.TaxPer = Convert.ToDecimal(TxtTaxPer.Text.Trim());
//Entity_TaxMaster.EffectiveFrom = Convert.ToDateTime(TXTEFFECTIVEDATE.Text.Trim());
Entity_TaxMaster.UserId = Convert.ToInt32(Session["UserId"]);
Entity_TaxMaster.LoginDate = DateTime.Now;
////Entity_TaxMaster.TaxTypeID = Convert.ToInt32(RdoTaxType.SelectedValue.ToString());
InsertRow = Obj_TaxMaster.InsertRecord(ref Entity_TaxMaster, out StrError);
for (int i = 0; i < GridDetails.Rows.Count; i++)
{
Entity_TaxMaster.TaxId = InsertRow;
if ((GridDetails.Rows[i].Cells[2]).Text != " ")
{
Entity_TaxMaster.ApplicableDate = DateTime.Parse((GridDetails.Rows[i].Cells[2]).Text);
}
else
{
Entity_TaxMaster.ApplicableDate = DateTime.Parse(DateTime.Now.ToString("dd/MMM/yyyy"));
}
Entity_TaxMaster.GST = Convert.ToDecimal(GridDetails.Rows[i].Cells[1].Text.ToString());
InserRowDtls = Obj_TaxMaster.InsertTaxtls(ref Entity_TaxMaster, out StrError);
}
if (InsertRow != 0)
{
obj_Comman.ShowPopUpMsg("Record Saved Successfully", this.Page);
MakeEmptyForm();
Entity_TaxMaster = null;
Obj_TaxMaster = null;
}
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
public int DeleteRecord(ref TaxMaster Entity_Call, out string strError)
{
int iDelete = 0;
strError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(TaxMaster._Action, SqlDbType.BigInt);
SqlParameter pCategoryId = new SqlParameter(TaxMaster._TaxId, SqlDbType.BigInt);
SqlParameter pDeletedBy = new SqlParameter(TaxMaster._UserId, SqlDbType.BigInt);
SqlParameter pDeletedDate = new SqlParameter(TaxMaster._LoginDate, SqlDbType.DateTime);
pAction.Value = 3;
pCategoryId.Value = Entity_Call.TaxId;
pDeletedBy.Value = Entity_Call.UserId;
pDeletedDate.Value = Entity_Call.LoginDate;
SqlParameter[] Param = new SqlParameter[] { pAction, pCategoryId, pDeletedBy, pDeletedDate };
Open(CONNECTION_STRING);
BeginTransaction();
iDelete = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, TaxMaster.SP_ItemCategory, Param);
if (iDelete > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
strError = ex.Message;
}
finally
{
Close();
}
return(iDelete);
}
public int InsertTaxtls(ref TaxMaster Entity_TaxMaster, out string StrError)
{
int InsertRow = 0;
StrError = string.Empty;
try
{
SqlParameter PAction = new SqlParameter(TaxMaster._Action, SqlDbType.BigInt);
SqlParameter PTaxId = new SqlParameter(TaxMaster._TaxId, SqlDbType.BigInt);
SqlParameter PGST = new SqlParameter(TaxMaster._GST, SqlDbType.Decimal);
SqlParameter PApplicableDate = new SqlParameter(TaxMaster._ApplicableDate, SqlDbType.DateTime);
PAction.Value = 8;
PTaxId.Value = Entity_TaxMaster.TaxId;
PGST.Value = Entity_TaxMaster.GST;
PApplicableDate.Value = Entity_TaxMaster.ApplicableDate;
SqlParameter[] ParamArray = new SqlParameter[] { PAction, PTaxId, PGST, PApplicableDate };
Open(Setting.CONNECTION_STRING);
BeginTransaction();
InsertRow = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, "SP_TaxMaster", ParamArray);
if (InsertRow != 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
StrError = ex.Message;
}
finally
{
Close();
}
return(InsertRow);
}
private void BtnInsertUpdate_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(TxtCGST.Text.ToString()))
{
messageShow.singlemsgtext("CGST should not be empty");
TxtCGST.Focus();
return;
}
if (string.IsNullOrEmpty(TxtSGST.Text.ToString()))
{
messageShow.singlemsgtext("SGST should not be empty");
TxtSGST.Focus();
return;
}
if (string.IsNullOrEmpty(TxtIGST.Text.ToString()))
{
messageShow.singlemsgtext("IGST should not be empty");
TxtIGST.Focus();
return;
}
var tax_master = new TaxMaster
{
CGST = Convert.ToDecimal(TxtCGST.Text.ToString()),
SGST = Convert.ToDecimal(TxtSGST.Text.ToString()),
IGST = Convert.ToDecimal(TxtIGST.Text.ToString()),
IsActive = ChkBoxIsActive.Checked ? 1 : 0,
OperationType = SelectedTaxCode == 0 ? 1 : 2
};
int id = _instanceRepository.InsertUpdateDeleteTaxMaster(tax_master);
if (id <= 0)
{
messageShow.singlemsgtext("Can't add one or more tax details");
}
GetTaxLedgerList();
TxtCGST.Focus();
}
catch (Exception _exception)
{
CmC.InsertException(_exception);
messageShow.singlemsgtext(CmC.ExceptionErrorMessage);
}
}
public TaxMaster add(TaxMaster item)
{
logger.Info("start addTaxMaster: ");
try
{
var identity = User.Identity as ClaimsIdentity;
int compid = 0, userid = 0;
// Access claims
foreach (Claim claim in identity.Claims)
{
if (claim.Type == "compid")
{
compid = int.Parse(claim.Value);
}
if (claim.Type == "userid")
{
userid = int.Parse(claim.Value);
}
}
item.CompanyId = compid;
if (item == null)
{
throw new ArgumentNullException("item");
}
logger.Info("User ID : {0} , Company Id : {1}", compid, userid);
context.AddTaxMaster(item);
logger.Info("End Add : ");
return(item);
}
catch (Exception ex)
{
logger.Error("Error in AddTaxMaster " + ex.Message);
logger.Info("End AddTaxMaster: ");
return(null);
}
}
public int Remove_TaxMaster(TaxMaster _user)
{
SqlParameter[] param = { new SqlParameter("@TaxId", _user.TaxId) };
return(_da.Execute("Delete_TaxMaster", param));
}
public int UpdateTaskDetails(ref TaxMaster Entity_TaxMaster, out string StrError)
{
throw new NotImplementedException();
}
