InsertMsgDetailExt(Int32 MsgId, Int32 ToPartyId, Int32 Msgstatusid)
{
cmd = new SqlCommand();
cmd.CommandText = "InsertMsgDetailExt";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MsgId", SqlDbType.Int));
cmd.Parameters["@MsgId"].Direction = ParameterDirection.Input;
cmd.Parameters["@MsgId"].Value = MsgId;
cmd.Parameters.Add(new SqlParameter("@ToPartyId", SqlDbType.Int));
cmd.Parameters["@ToPartyId"].Direction = ParameterDirection.Input;
cmd.Parameters["@ToPartyId"].Value = ToPartyId;
cmd.Parameters.Add(new SqlParameter("@Msgstatusid", SqlDbType.Int));
cmd.Parameters["@Msgstatusid"].Direction = ParameterDirection.Input;
cmd.Parameters["@Msgstatusid"].Value = Msgstatusid;
cmd.Parameters.Add(new SqlParameter("@MsgDetailId", SqlDbType.Int));
cmd.Parameters["@MsgDetailId"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls.ExecuteNonQuery(cmd);
result = Convert.ToInt32(cmd.Parameters["@MsgDetailId"].Value.ToString());
return(result);
// return (result != -1);
}
public bool InsertSpamEmail(String SpamEmailId, Boolean AllowEmail, Int32 MsgId, Int32 Partyid)
{
cmd = new SqlCommand();
cmd.CommandText = "InsertSpamEmail";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@SpamEmailId", SqlDbType.NVarChar));
cmd.Parameters["@SpamEmailId"].Value = SpamEmailId;
cmd.Parameters.Add(new SqlParameter("@MsgId", SqlDbType.Int));
cmd.Parameters["@MsgId"].Value = MsgId;
cmd.Parameters.Add(new SqlParameter("@AllowEmail", SqlDbType.Bit));
cmd.Parameters["@AllowEmail"].Value = AllowEmail;
cmd.Parameters.Add(new SqlParameter("@PartyId", SqlDbType.Int));
cmd.Parameters["@PartyId"].Value = Partyid;
cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
cmd.Parameters["@CID"].Value = HttpContext.Current.Session["Comid"].ToString(); // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls.ExecuteNonQuery(cmd);
return(result != -1);
}
public Int32 InsertMsgMaster(Int32 FromPartyId, String MsgSubject, String MsgDetail, String Signature, Boolean Picture, String str)
{
cmd = new SqlCommand();
cmd.CommandText = "InsertMsgMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@FromPartyId", SqlDbType.Int));
cmd.Parameters["@FromPartyId"].Direction = ParameterDirection.Input;
cmd.Parameters["@FromPartyId"].Value = FromPartyId;
cmd.Parameters.Add(new SqlParameter("@MsgSubject", SqlDbType.NVarChar));
cmd.Parameters["@MsgSubject"].Value = MsgSubject;
cmd.Parameters.Add(new SqlParameter("@MsgDetail", SqlDbType.NVarChar));
cmd.Parameters["@MsgDetail"].Value = MsgDetail;
cmd.Parameters.Add(new SqlParameter("@Signature", SqlDbType.NVarChar));
cmd.Parameters["@Signature"].Value = Signature;
cmd.Parameters.Add(new SqlParameter("@str", SqlDbType.NVarChar));
cmd.Parameters["@str"].Value = str;
cmd.Parameters.Add(new SqlParameter("@Picture", SqlDbType.Bit));
cmd.Parameters["@Picture"].Value = Picture;
cmd.Parameters.Add(new SqlParameter("@MsgId", SqlDbType.Int));
cmd.Parameters["@MsgId"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls.ExecuteNonQuery(cmd);
result = Convert.ToInt32(cmd.Parameters["@MsgId"].Value.ToString());
return(result);
}
public Int32 InsertAccountMasterParty(String Accountid, Int32 ClassId, Int32 GroupId, String AccountName, String AccountDate, String Whid)
{
cmd = new SqlCommand();
cmd.CommandText = "InsertAccountMasterParty";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@AccountId", SqlDbType.NVarChar));
cmd.Parameters["@AccountId"].Value = Accountid;
cmd.Parameters.Add(new SqlParameter("@ClassId", SqlDbType.Int));
cmd.Parameters["@ClassId"].Value = ClassId;
cmd.Parameters.Add(new SqlParameter("@GroupId", SqlDbType.Int));
cmd.Parameters["@GroupId"].Value = GroupId;
cmd.Parameters.Add(new SqlParameter("@AccountName", SqlDbType.NVarChar));
cmd.Parameters["@AccountName"].Value = AccountName;
cmd.Parameters.Add(new SqlParameter("@AccountDate", SqlDbType.DateTime));
cmd.Parameters["@AccountDate"].Value = AccountDate;
cmd.Parameters.Add(new SqlParameter("@Status", SqlDbType.Bit));
cmd.Parameters["@Status"].Value = 1;
cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
cmd.Parameters["@CID"].Value = HttpContext.Current.Session["Comid"].ToString(); // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@Whid", SqlDbType.NVarChar));
cmd.Parameters["@Whid"].Value = Whid; // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int));
cmd.Parameters["@Id"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls.ExecuteNonQuery(cmd);
result = Convert.ToInt32(cmd.Parameters["@Id"].Value.ToString());
return(result);
}
public Int32 InsertMsgMasterExt(Int32 FromPartyId, String MsgSubject, String MsgDetail, String FromEmail)
{
cmd = new SqlCommand();
cmd.CommandText = "InsertMsgMasterExt";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@FromPartyId", SqlDbType.Int));
cmd.Parameters["@FromPartyId"].Direction = ParameterDirection.Input;
cmd.Parameters["@FromPartyId"].Value = FromPartyId;
cmd.Parameters.Add(new SqlParameter("@MsgSubject", SqlDbType.NVarChar));
cmd.Parameters["@MsgSubject"].Value = MsgSubject;
cmd.Parameters.Add(new SqlParameter("@MsgDetail", SqlDbType.NVarChar));
cmd.Parameters["@MsgDetail"].Value = MsgDetail;
cmd.Parameters.Add(new SqlParameter("@FromEmail", SqlDbType.NVarChar));
cmd.Parameters["@FromEmail"].Value = FromEmail;
cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
cmd.Parameters["@CID"].Value = HttpContext.Current.Session["Comid"].ToString(); // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@MsgId", SqlDbType.Int));
cmd.Parameters["@MsgId"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls.ExecuteNonQuery(cmd);
result = Convert.ToInt32(cmd.Parameters["@MsgId"].Value.ToString());
return(result);
}
public bool UpdatePageMaster(Int32 PageId, Int32 PageTypeId, String PageName, String PageTitle, String PageDescription)
{
cmd = new SqlCommand();
cmd.CommandText = "UpdatePageMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PageId", SqlDbType.Int));
cmd.Parameters["@PageId"].Value = PageId;
cmd.Parameters.Add(new SqlParameter("@PageTypeId", SqlDbType.Int));
cmd.Parameters["@PageTypeId"].Value = PageTypeId;
cmd.Parameters.Add(new SqlParameter("@PageName", SqlDbType.NVarChar));
cmd.Parameters["@PageName"].Value = PageName;
cmd.Parameters.Add(new SqlParameter("@PageTitle", SqlDbType.NVarChar));
cmd.Parameters["@PageTitle"].Value = PageTitle;
cmd.Parameters.Add(new SqlParameter("@PageDescription", SqlDbType.NVarChar));
cmd.Parameters["@PageDescription"].Value = PageDescription;
//cmd.Parameters.Add(new SqlParameter("@DepartmentId", SqlDbType.Int));
//cmd.Parameters["@DepartmentId"].Value = DepartmentId;
//cmd.Parameters.Add(new SqlParameter("@DepartmentName", SqlDbType.NVarChar));
//cmd.Parameters["@DepartmentName"].Value = DepartmentName;
////cmd.Parameters.Add(new SqlParameter("@DepartmentName", SqlDbType.NVarChar));
////cmd.Parameters["@DepartmentName"].Value = DepartmentName;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
int result = DatabaseCls.ExecuteNonQuery(cmd);
return(result != -1);
}
public DataTable SelectInventorySubCategoryMaster()
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectInventorySubCategoryMaster";
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectPayFrequencyMaster()
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectACCOUNTINGDesg";
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectQuantityTypeMaster()
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectQuantityTypeMaster";
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectMsgIdUsingMsgDetailIdExt(Int32 MsgDetailId)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectMsgIdUsingMsgDetailIdExt";
cmd.Parameters.Add(new SqlParameter("@MsgDetailId", SqlDbType.Int));
cmd.Parameters["@MsgDetailId"].Value = MsgDetailId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectEmpEmail(Int32 EmployeeId)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectEmpEmail";
cmd.Parameters.Add(new SqlParameter("@EmployeeId", SqlDbType.Int));
cmd.Parameters["@EmployeeId"].Value = EmployeeId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectPartyMasterWithoutEmployeeType(String Whid)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectPartyMasterWithoutEmployeeType";
cmd.Parameters.Add(new SqlParameter("@Whid", SqlDbType.NVarChar));
cmd.Parameters["@Whid"].Value = Whid;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable Empid(String Whid)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = " Select distinct EmployeeMaster.EmployeeMasterID from EmployeeMaster inner join Party_master on Party_master.PartyID=EmployeeMaster.PartyID inner join User_master on User_master.PartyID=Party_master.PartyID inner join PartytTypeMaster on PartytTypeMaster.PartyTypeId=Party_master.PartyTypeId where PartytTypeMaster.PartType='Admin' and EmployeeMaster.Whid='" + Whid + "'";
//cmd.CommandText = " Select distinct EmployeeMaster.EmployeeMasterID from EmployeeMaster inner join Party_master on Party_master.PartyID=EmployeeMaster.PartyID inner join User_master on User_master.PartyID=Party_master.PartyID where User_master.UserID='" + HttpContext.Current.Session["UserId"].ToString() + "'";
dt = DatabaseCls.FillAdapterque(cmd);
return(dt);
}
public DataTable SelectInventoryMasterInNewPage(Int32 InvId)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectInventoryMasterInNewPage";
cmd.Parameters.Add(new SqlParameter("@InvId", SqlDbType.Int));
cmd.Parameters["@InvId"].Value = InvId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectDesignationMasterbyEmpId(Int32 EmployeeId)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectDesignationMasterbyEmpId";
cmd.Parameters.Add(new SqlParameter("@EmployeeID", SqlDbType.Int));
cmd.Parameters["@EmployeeID"].Value = EmployeeId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectPartyTypeMasterwithoutEmployee()
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectPartyTypeMasterwithoutEmployee";
cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
cmd.Parameters["@CID"].Value = HttpContext.Current.Session["Comid"].ToString(); // CompanyLoginId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectPageMasterwithPageType(Int32 PageTypeId)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectPageMasterwithPageType";
cmd.Parameters.Add(new SqlParameter("@PageTypeId", SqlDbType.Int));
cmd.Parameters["@PageTypeId"].Value = PageTypeId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectMsgforSendBox(Int32 FromPartyId)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectMsgforSendBox";
cmd.Parameters.Add(new SqlParameter("@FromPartyId", SqlDbType.Int));
cmd.Parameters["@FromPartyId"].Value = FromPartyId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
//=== added by alkesh 19-02-2009
public DataTable SelectDocumentMasterByID(int DocumentId)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectDoucmentMasterByID";
cmd.Parameters.Add(new SqlParameter("@DocumentId", SqlDbType.Int));
cmd.Parameters["@DocumentId"].Value = DocumentId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable selectIPMaster(string comid)
{
cmd = new SqlCommand();
DataTable dtIp = new DataTable();
cmd.CommandText = "selectIPMaster";
cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
cmd.Parameters["@CID"].Value = comid; // CompanyLoginId;
dtIp = DatabaseCls.FillAdapter(cmd);
return(dtIp);
}
public DataTable selectCompanyMaster()
{
cmd = new SqlCommand();
DataTable dtr = new DataTable();
cmd.CommandText = "selectCompanyMaster";
cmd.Parameters.Add(new SqlParameter("@CompanyName", SqlDbType.NVarChar));
cmd.Parameters["@CompanyName"].Value = HttpContext.Current.Session["comid"].ToString(); // CompanyLoginId;
dtr = DatabaseCls.FillAdapter(cmd);
return(dtr);
}
public DataTable SelectPartynamebypartyid(Int32 Partyid)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectPartynamebypartyid";
cmd.Parameters.Add(new SqlParameter("@PartyId", SqlDbType.Int));
cmd.Parameters["@PartyId"].Value = Partyid;
cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
cmd.Parameters["@CID"].Value = HttpContext.Current.Session["Comid"].ToString(); // CompanyLoginId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectDesignationMasterwithDataDept(String Whid)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectDesignationMasterwithDataDept";
cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
cmd.Parameters["@CID"].Value = HttpContext.Current.Session["Comid"].ToString(); // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@Whid", SqlDbType.NVarChar));
cmd.Parameters["@Whid"].Value = Whid; // CompanyLoginId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectParty_MasterbyPartyTypeId(Int32 DesignationId, String Whid)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectParty_MasterbyPartyTypeId";
cmd.Parameters.Add(new SqlParameter("@PartyTypeId", SqlDbType.Int));
cmd.Parameters["@PartyTypeId"].Value = DesignationId;
cmd.Parameters.Add(new SqlParameter("@Whid", SqlDbType.NVarChar));
cmd.Parameters["@Whid"].Value = Whid; // CompanyLoginId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable selectEmployeewithDesignation(Int32 DesignationId, String Whid)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "selectEmployeewithDesignation";
cmd.Parameters.Add(new SqlParameter("@DesignationId", SqlDbType.Int));
cmd.Parameters["@DesignationId"].Value = DesignationId;
cmd.Parameters.Add(new SqlParameter("@Whid", SqlDbType.NVarChar));
cmd.Parameters["@Whid"].Value = Whid; // CompanyLoginId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectCompanyEmaildetail(Int32 ID)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectCompanyEmaildetail";
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int));
cmd.Parameters["@ID"].Value = ID;
//cmd.Parameters.Add(new SqlParameter("@PartyId", SqlDbType.Int));
//cmd.Parameters["@PartyId"].Value = PartyId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public DataTable SelectEmployeewithDesgDeptName(String Whid)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectEmployeewithDesgDeptName";
cmd.Parameters.Add(new SqlParameter("@Whid", SqlDbType.NVarChar));
cmd.Parameters["@Whid"].Value = Whid; // CompanyLoginId;
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public Int32 InsertInventoryCategoryMaster(String InvCategoryName)
{
cmd = new SqlCommand();
cmd.CommandText = "InsertInventoryCategoryMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@InvCategoryName", SqlDbType.NVarChar));
cmd.Parameters["@InvCategoryName"].Value = InvCategoryName;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls.ExecuteNonQuery(cmd);
return(result);
}
public DataTable SelectPartyMasterAll(string id)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectPartyMasterAll";
cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.NVarChar));
cmd.Parameters["@id"].Value = id;
cmd.CommandType = CommandType.StoredProcedure;
SqlCommand cmdd = new SqlCommand();
dt = DatabaseCls.FillAdapter(cmd);
return(dt);
}
public Int32 InsertPartyMasterMess(Int32 PartyTypeId, Int32 AccountId, String PartyName, String ContactPerson, String Address, String City, String State, String Country, String Website, String Email, String Whid)
{
cmd = new SqlCommand();
cmd.CommandText = "InsertPartyMasterMess";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PartyTypeId", SqlDbType.Int));
cmd.Parameters["@PartyTypeId"].Value = PartyTypeId;
cmd.Parameters.Add(new SqlParameter("@AccountId", SqlDbType.Int));
cmd.Parameters["@AccountId"].Value = AccountId;
cmd.Parameters.Add(new SqlParameter("@PartyName", SqlDbType.NVarChar));
cmd.Parameters["@PartyName"].Value = PartyName;
cmd.Parameters.Add(new SqlParameter("@ContactPerson", SqlDbType.NVarChar));
cmd.Parameters["@ContactPerson"].Value = ContactPerson;
cmd.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar));
cmd.Parameters["@Address"].Value = Address;
cmd.Parameters.Add(new SqlParameter("@City", SqlDbType.NVarChar));
cmd.Parameters["@City"].Value = City;
cmd.Parameters.Add(new SqlParameter("@State", SqlDbType.NVarChar));
cmd.Parameters["@State"].Value = State;
cmd.Parameters.Add(new SqlParameter("@Country", SqlDbType.NVarChar));
cmd.Parameters["@Country"].Value = Country;
cmd.Parameters.Add(new SqlParameter("@Website", SqlDbType.NVarChar));
cmd.Parameters["@Website"].Value = Website;
cmd.Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar));
cmd.Parameters["@Email"].Value = Email;
cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
cmd.Parameters["@CID"].Value = HttpContext.Current.Session["Comid"].ToString(); // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@Whid", SqlDbType.NVarChar));
cmd.Parameters["@Whid"].Value = Whid; // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(new SqlParameter("@PartyId", SqlDbType.Int));
cmd.Parameters["@PartyId"].Direction = ParameterDirection.Output;
Int32 result = DatabaseCls.ExecuteNonQuery(cmd);
result = Convert.ToInt32(cmd.Parameters["@PartyId"].Value.ToString());
return(result);
}
