public CRM_ConExecStatus_Info_Ety CRM_Authorize_KW_DSR(Hashtable ht) { CRM_ConExecStatus_Info_Ety ocrm_ConExecStatus_Info_ety = new CRM_ConExecStatus_Info_Ety(); cn1.Open(); string strProc = string.Empty; try { SqlParameter[] dsrparam = new SqlParameter[7]; dsrparam[0] = new SqlParameter("@Inempid", SqlDbType.SmallInt); dsrparam[1] = new SqlParameter("@Indsrid", SqlDbType.VarChar); dsrparam[2] = new SqlParameter("@InAuth", SqlDbType.VarChar); dsrparam[3] = new SqlParameter("@InDsrAuth", SqlDbType.VarChar); dsrparam[4] = new SqlParameter("@UsrId", SqlDbType.SmallInt); dsrparam[5] = new SqlParameter("@Result", SqlDbType.VarChar, 200); dsrparam[5].Direction = ParameterDirection.InputOutput; dsrparam[6] = new SqlParameter("@ExecStatus", SqlDbType.TinyInt); dsrparam[6].Direction = ParameterDirection.InputOutput; dsrparam[0].Value = Convert.ToInt32(ht["EmpId"]); dsrparam[1].Value = ht["DsrId"]; dsrparam[2].Value = ht["DsrAuth"]; dsrparam[3].Value = ht["DsrSlnoAuth"]; dsrparam[4].Value = Convert.ToInt16(ht["UserId"]); dsrparam[5].Value = ""; dsrparam[6].Value = 0; //int i = SqlHelper.ExecuteNonQuery(setCon(), CommandType.StoredProcedure, "dsr_multiplieAuthorization_Proc", dsrparam); strProc = "dsr_multiplieAuthorization_Proc"; if (strProc != string.Empty) { SqlHelper.ExecuteNonQuery(cn1, CommandType.StoredProcedure, strProc, dsrparam); } ocrm_ConExecStatus_Info_ety.ExecStatus = Convert.ToByte(dsrparam[6].Value.ToString()); ocrm_ConExecStatus_Info_ety.Confirm = dsrparam[6].Value.ToString(); if (cn1 != null && cn1.State == ConnectionState.Open) { cn1.Close(); } } catch (Exception msg) { if (cn1 != null) { cn1.Close(); } ocrm_ConExecStatus_Info_ety.Confirm = msg.Message.Replace("'", ""); ocrm_ConExecStatus_Info_ety.ExecStatus = 0; } finally { if (cn1.State == ConnectionState.Open) { cn1.Close(); } if (cn1 != null) { cn1.Dispose(); } } return(ocrm_ConExecStatus_Info_ety); }
public CRM_ConExecStatus_Info_Ety CRM_Save_KW_TravelExpenses(Hashtable ht, Hashtable dtParam) { CRM_ConExecStatus_Info_Ety ocrm_ConExecStatus_Info_ety = new CRM_ConExecStatus_Info_Ety(); //SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); cn1.Open(); SqlTransaction st = cn1.BeginTransaction(); string strProc = string.Empty; try { SqlParameter[] dsrparam = new SqlParameter[18]; dsrparam[0] = new SqlParameter("@Intrvexpid", SqlDbType.BigInt); dsrparam[0].Direction = ParameterDirection.InputOutput; dsrparam[1] = new SqlParameter("@Inempid", SqlDbType.SmallInt); dsrparam[2] = new SqlParameter("@Inarea", SqlDbType.SmallInt); dsrparam[3] = new SqlParameter("@Intourfrmdate", SqlDbType.SmallDateTime); dsrparam[4] = new SqlParameter("@Intourtodate", SqlDbType.SmallDateTime); dsrparam[5] = new SqlParameter("@Intourauthorizedby", SqlDbType.SmallInt); dsrparam[6] = new SqlParameter("@Inadvancedrawn", SqlDbType.Decimal); dsrparam[7] = new SqlParameter("@Indeptime", SqlDbType.VarChar); dsrparam[8] = new SqlParameter("@Inarivaltime", SqlDbType.VarChar); dsrparam[9] = new SqlParameter("@Inrepdatetime", SqlDbType.SmallDateTime); dsrparam[10] = new SqlParameter("@Inamtclaimed", SqlDbType.Decimal); dsrparam[11] = new SqlParameter("@Inamtdisallowed", SqlDbType.Decimal); dsrparam[12] = new SqlParameter("@Inamtpassed", SqlDbType.Decimal); dsrparam[13] = new SqlParameter("@Inapprovedby", SqlDbType.SmallInt); dsrparam[14] = new SqlParameter("@Inusrid", SqlDbType.SmallInt); dsrparam[15] = new SqlParameter("@Inmode", SqlDbType.VarChar, 50); dsrparam[16] = new SqlParameter("@execstatus", SqlDbType.SmallInt); dsrparam[16].Direction = ParameterDirection.Output; dsrparam[17] = new SqlParameter("@result", SqlDbType.VarChar, 50); dsrparam[17].Direction = ParameterDirection.Output; dsrparam[0].Value = ht["trvexpid"]; dsrparam[1].Value = Convert.ToInt16(ht["empid"]); dsrparam[2].Value = Convert.ToInt16(ht["area"]); dsrparam[3].Value = Convert.ToDateTime(ht["tourfrmdate"]); dsrparam[4].Value = Convert.ToDateTime(ht["tourtodate"]); dsrparam[5].Value = Convert.ToInt16(ht["tourauthorizedby"]); dsrparam[6].Value = Convert.ToDecimal(ht["advancedrawn"]); dsrparam[7].Value = ht["deptime"]; dsrparam[8].Value = ht["arivaltime"]; dsrparam[9].Value = Convert.ToDateTime(ht["repdatetime"]); dsrparam[10].Value = Convert.ToDecimal(ht["amtclaimed"]); dsrparam[11].Value = Convert.ToDecimal(ht["amtdisallowed"]); dsrparam[12].Value = Convert.ToDecimal(ht["amtpassed"]); dsrparam[13].Value = ht["approvedby"]; dsrparam[14].Value = Convert.ToInt16(ht["UserId"]); dsrparam[15].Value = ht["Mode"]; dsrparam[16].Value = 0; dsrparam[17].Value = "hh"; strProc = "DSR_TravellingexpenseMast_proc"; if (strProc != string.Empty) { SqlHelper.ExecuteNonQuery(st, CommandType.StoredProcedure, strProc, dsrparam); } if (Convert.ToInt16(dsrparam[16].Value.ToString()) == 0) { st.Rollback(); cn1.Close(); ocrm_ConExecStatus_Info_ety.Confirm = dsrparam[17].Value.ToString(); ocrm_ConExecStatus_Info_ety.ExecStatus = Convert.ToByte(dsrparam[16].Value.ToString()); return(ocrm_ConExecStatus_Info_ety); } ocrm_ConExecStatus_Info_ety.ExecStatus = Convert.ToByte(dsrparam[16].Value.ToString()); ocrm_ConExecStatus_Info_ety.Confirm = dsrparam[17].Value.ToString(); if (ht["Mode"].ToString() != "DELETE") { SqlParameter[] dsrDtparam = new SqlParameter[17]; dsrDtparam[0] = new SqlParameter("@Intravellid", SqlDbType.BigInt); dsrDtparam[1] = new SqlParameter("@Intrvdate", SqlDbType.VarChar); dsrDtparam[2] = new SqlParameter("@Inparticulars", SqlDbType.VarChar); dsrDtparam[3] = new SqlParameter("@Inmodeoftravell", SqlDbType.VarChar); dsrDtparam[4] = new SqlParameter("@Infare", SqlDbType.VarChar); dsrDtparam[5] = new SqlParameter("@Inlodging", SqlDbType.VarChar); dsrDtparam[6] = new SqlParameter("@Inlocconvy", SqlDbType.VarChar); dsrDtparam[6] = new SqlParameter("@InPOrderVal", SqlDbType.VarChar); dsrDtparam[7] = new SqlParameter("@InCollectAmt", SqlDbType.VarChar); dsrDtparam[8] = new SqlParameter("@InparticularsTo", SqlDbType.VarChar); dsrDtparam[9] = new SqlParameter("@Inmiscexp", SqlDbType.VarChar); dsrDtparam[10] = new SqlParameter("@Inremarks", SqlDbType.VarChar); dsrDtparam[11] = new SqlParameter("@Inusrid", SqlDbType.SmallInt); dsrDtparam[12] = new SqlParameter("@Insupportingflag", SqlDbType.VarChar); dsrDtparam[13] = new SqlParameter("@Inauthflag", SqlDbType.VarChar); dsrDtparam[14] = new SqlParameter("@Inmode", SqlDbType.VarChar, 50); dsrDtparam[15] = new SqlParameter("@execstatus", SqlDbType.SmallInt); dsrDtparam[15].Direction = ParameterDirection.Output; dsrDtparam[16] = new SqlParameter("@result", SqlDbType.VarChar, 50); dsrDtparam[16].Direction = ParameterDirection.Output; dsrDtparam[0].Value = Convert.ToInt64(dsrparam[0].Value); dsrDtparam[1].Value = dtParam["Trvdate"]; dsrDtparam[2].Value = dtParam["particulars"]; dsrDtparam[3].Value = dtParam["modeoftravell"]; // Convert.ToInt16(ht["tourfrmdate"]); dsrDtparam[4].Value = dtParam["fare"]; dsrDtparam[5].Value = dtParam["lodging"]; dsrDtparam[6].Value = dtParam["locconvy"]; dsrDtparam[7].Value = dtParam["extconvy"]; dsrDtparam[8].Value = dtParam["luggagechrg"]; dsrDtparam[6].Value = dtParam["OrderVal"]; dsrDtparam[7].Value = dtParam["ColAmt"]; dsrDtparam[8].Value = dtParam["particularsTo"]; dsrDtparam[9].Value = dtParam["miscexp"]; dsrDtparam[10].Value = dtParam["remarks"]; dsrDtparam[11].Value = Convert.ToInt16(ht["UserId"]); dsrDtparam[12].Value = dtParam["supportingflag"]; dsrDtparam[13].Value = dtParam["AuthFlg"]; dsrDtparam[14].Value = dtParam["Mode"]; dsrDtparam[15].Value = 0; dsrDtparam[16].Value = "hh"; strProc = "DSR_Travellingexpdetails_proc"; if (strProc != string.Empty) { SqlHelper.ExecuteNonQuery(st, CommandType.StoredProcedure, strProc, dsrDtparam); } if (Convert.ToInt16(dsrDtparam[15].Value.ToString()) == 0) { st.Rollback(); cn1.Close(); ocrm_ConExecStatus_Info_ety.Confirm = dsrDtparam[16].Value.ToString(); ocrm_ConExecStatus_Info_ety.ExecStatus = Convert.ToByte(dsrDtparam[15].Value.ToString()); return(ocrm_ConExecStatus_Info_ety); } ocrm_ConExecStatus_Info_ety.ExecStatus = Convert.ToByte(dsrDtparam[15].Value.ToString()); ocrm_ConExecStatus_Info_ety.Confirm = dsrDtparam[16].Value.ToString(); } st.Commit(); if (cn1 != null && cn1.State == ConnectionState.Open) { cn1.Close(); } } catch (Exception msg) { st.Rollback(); if (cn1 != null) { cn1.Close(); } if (res == null) { res = msg.Message; } ocrm_ConExecStatus_Info_ety.Confirm = msg.Message; ocrm_ConExecStatus_Info_ety.ExecStatus = 0; } finally { if (cn1.State == ConnectionState.Open) { cn1.Close(); } if (cn1 != null) { cn1.Dispose(); } } return(ocrm_ConExecStatus_Info_ety); }
public CRM_ConExecStatus_Info_Ety CRM_Save_KW_DSR_Details(Hashtable ht, string ProcType) { CRM_ConExecStatus_Info_Ety ocrm_ConExecStatus_Info_ety = new CRM_ConExecStatus_Info_Ety(); cn1.Open(); string strProc = string.Empty; try { SqlParameter[] dsrparam = new SqlParameter[14]; dsrparam[0] = new SqlParameter("@Indsrid", SqlDbType.BigInt); dsrparam[1] = new SqlParameter("@Indsrdate", SqlDbType.SmallDateTime); dsrparam[2] = new SqlParameter("@Inempid", SqlDbType.SmallInt); dsrparam[3] = new SqlParameter("@Indsroption", SqlDbType.SmallInt); dsrparam[4] = new SqlParameter("@Inareasvisited", SqlDbType.VarChar, 4000); dsrparam[5] = new SqlParameter("@Inpoamount", SqlDbType.Decimal); dsrparam[6] = new SqlParameter("@Inchequeamount", SqlDbType.Decimal); dsrparam[7] = new SqlParameter("@Incashcollected", SqlDbType.Decimal); dsrparam[8] = new SqlParameter("@Inremarks", SqlDbType.VarChar, 4000); dsrparam[9] = new SqlParameter("@InAccId", SqlDbType.BigInt); dsrparam[10] = new SqlParameter("@Inusrid", SqlDbType.SmallInt); dsrparam[11] = new SqlParameter("@Inmode", SqlDbType.VarChar, 50); dsrparam[12] = new SqlParameter("@execstatus", SqlDbType.SmallInt); dsrparam[13] = new SqlParameter("@result", SqlDbType.VarChar, 500); dsrparam[12].Direction = ParameterDirection.Output; dsrparam[13].Direction = ParameterDirection.Output; dsrparam[0].Value = Convert.ToInt64(ht["DsrId"]); dsrparam[1].Value = Convert.ToDateTime(ht["DsrDare"]); dsrparam[2].Value = Convert.ToInt16(ht["EmpId"]); dsrparam[3].Value = Convert.ToInt16(ht["DsrMode"]); dsrparam[4].Value = ht["DsrArea"]; dsrparam[5].Value = Convert.ToDecimal(ht["PoAmt"]); dsrparam[6].Value = Convert.ToDecimal(ht["ChqAmt"]); dsrparam[7].Value = Convert.ToDecimal(ht["CashAmt"]); dsrparam[8].Value = ht["Remarks"]; dsrparam[9].Value = Convert.ToInt64(ht["AccId"]); dsrparam[10].Value = Convert.ToInt16(ht["UserId"]); dsrparam[11].Value = ht["Mode"]; dsrparam[12].Value = 0; dsrparam[13].Value = "hh"; strProc = "DSR_dailySalesRpt_proc"; if (ProcType == "Mast") { strProc = "DSR_dailySalesRpt_proc"; } else if (ProcType == "MastAuth") { strProc = "DSR_dailySalesRptMastAuth_proc"; } else if (ProcType == "Auth") { strProc = "DSR_dailySalesRptAuth_proc"; } if (strProc != string.Empty) { SqlHelper.ExecuteNonQuery(cn1, CommandType.StoredProcedure, strProc, dsrparam); } ocrm_ConExecStatus_Info_ety.ExecStatus = Convert.ToByte(dsrparam[12].Value.ToString()); ocrm_ConExecStatus_Info_ety.Confirm = dsrparam[13].Value.ToString(); if (cn1 != null && cn1.State == ConnectionState.Open) { cn1.Close(); } } catch (Exception msg) { if (cn1 != null) { cn1.Close(); } ocrm_ConExecStatus_Info_ety.Confirm = msg.Message.Replace("'", ""); ocrm_ConExecStatus_Info_ety.ExecStatus = 0; } finally { if (cn1.State == ConnectionState.Open) { cn1.Close(); } if (cn1 != null) { cn1.Dispose(); } } return(ocrm_ConExecStatus_Info_ety); }